This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The best way to build this would be to use the R tool to generate the graphic you need. If you only want to use the Charting tool, then you can trick the user by setting the bar color the same as the background (and remove axis lines) so it doesn't appear to be there.
I've attached an example solution using the Charting tool.
Thanks @CharlieS! Your workflow is very helpful - I will play around with it and incorporate it into my workflow.
I have one more question if you don't mind - is there a way to change the numeric data in number format into percentage format on the report? Currently, I am trying to use the Table tool and format the data by column.
The Charting tool will output a field type called a "Layout" field. These fields should appear with navy blue text in the Results window. To output a Layout field, you must use the Render tool in the Reporting tool category. Often times there are other Layout fields that can be combined with a Layout tool and then Rendered to Excel.
Thanks for the advice! It works and i can see the Chart in excel now. But not sure if you could advise me how can i combine the chart into my current output excel file together? I tried and it churned out 'The Picture can't be displayed'
It seems the chart only is viewable when i choose the Output Mode in Temporary Excel 2007 spreadsheet.