# How to plot disproportionate values in single graph with Excel

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.

-
In the legend, you could say in 10s, 100s, millions, etc next to the line? –  soandos Jul 24 '11 at 4:09
@Soandos I could do some sort of reduction but then I am showing 10th of a unit in one series, and another would be in \$10,000 of dollars. So I end up with odd groupings. –  Jim McKeeth Jul 24 '11 at 4:19
Im saying stick the scale on the ledgend not the axes –  soandos Jul 24 '11 at 4:25
@Soandos: If I just stick the sales in the legend then the series with values in to 100,000 will be the only one showing fluctuation as the rest will be flat along the bottom of the graph since their maximum value is not enough to even be a blip at that scale. –  Jim McKeeth Jul 24 '11 at 4:28
No, i mean write (in thousands) after the line –  soandos Jul 24 '11 at 4:53
show 1 more comment