I have multiple series of data that are on different scales and I would like to graph all of them in the same line chart based on percentage, but I want to label the points with the actual values. One series has values in 100's, another in 10's and another in 100,000's. If I chart them all together then only the series with the largest values shows up.
I added a percent column for each series, and then charted that. This gives me the lines I expect, but there is no way I could see to have the points show the actual values, and not the percentage value. So instead of a point showing 15% I want it to show $500.
What I would expect is the ability to plot each series on its own axis, but then remove the axis label and superimpose them all. Or perhaps tell Excel to plot based on percentage of whole.
I tried Stacked and 100% Stacked, but those didn't work. I could manually label each point, but that defeats the purpose of using a Excel to draw my graph.
I am using Excel 2010, but if there is another common or free tool (Numbers, etc.) that would work better, please let me know.
This is what I want it to look like, but with the series tied to the actual values instead of the percentages so I can show data labels.
Update: The values shown in the 3rd position (starts with the left end of the orange line at the top and going down) are 107,253 units, 22 units, 317 units, $61 million, 142 units, $130 million, and $798 million. So there is no natural factoring, grouping, etc. The interesting relationship is how they compare to the other values in the same series. That is what is depicted correctly now in the lines.