Forum Discussion
Graphing Multiple Series on one Graph
Hello all,
I have been asked to Graph a variety of different data series into one graph to see if any may relate to each other. The graph is intended to be a line graph, having 5 different lines, representing 5 different data series.
I believe this is possible, but just cannot remember how to do it.
An issue that I'm having is that the Data series has such different values, ranging from a series having values of <1.0 to series having values of >20,000. Is it possible to have a 'break' in the y-axis so that the gap between say... 100 on the y-axis to 20,000 on the y-axis is non-existent or would it be recommended to just add a secondary Y-axis for this series?
The dates are of significance, and should be on the x axis to show the timeline of these different values.
Any help here would be appreciated as my direct report has been asking this of me, and we're both stumped. I've attached a spreadsheet with the 5 series included.
Is anyone able to have these 5 series added to the same line graph in a legible manner without adjusting their values?
Thank-you so much in advance.
Toon
2 Replies
Hi Toon
Hi Toon,
This is possible by using multi axis chart, each scale should scale on different series. As an example, two sample chart images attached herewith (Multi Axis Line Chart and Multi Axis Spider Chart).
I hope for your data Multi-Axis Line chart is the best option.
Multi-Axis Line Chart tutorial
Multi-Axis Spider Chart tutorial
For more details check here.
Thanks,
There is no attachment, but yes, do use a secondary axis for the series that are much different from the others. If all series are very different it will be difficult. Perhaps multiplying or dividing values to come a common range of values could be a solution. If you can't upload a file, share a link that gives access to it on OneDrive, Dropbox or similar.
