Multiples bar charts into one
Hello,
I am trying to create a bar chart displaying the performance of various companies over several period of times. The problem is that my “chart” is actually the combination of 10 smaller ones.
Exemple:
Table2.JPG
Do you have any idea how I could obtain the same result using one graph instead of 10? Or any way of doing it in a way that allows me not to have to reformat the size of 10 charts anytime I add / remove a company from the sample!
Thank you very much!
Julien
Creating the bars is not really a problem but the labelling of each data point with it's value is.
You can create the bars using either multiple series in stacked bar format. You need to create extra series to pad and align the stack. Setting the fill of padding series to none.
Or you can use a bar/xy-scatter combination where the bars are actually custom x-error bars, see attached.
As for the labelling you can do that with additional xy-scatter series and data labels linked to cells to display the value.
Hi Andy,
Thank you for the answer, this is exactly what I am looking for!
I followed your instruction and so far my graph looks like what I want, but I struggle with the labelling as I do not really understand your "xy-scatter series and data labels" tweak.
Would you mind going into further details so that I can replicate?
Please find attached the current version of the file.
Test_Graph.xlsx
Kind regards,
Julien
I have done 1 set for you.
Use this addin to link data labels to cells.
http://www.appspro.com/Utilities/ChartLabeler.htm
Brilliant, thank you Andy!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks