Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Comparing incomparable
I want to create a simple (bar) chart where there would be sales compared
with number of shops compare with sales of chocolate compared with net profit/shop Of course such a chart would look terrible since the it would compare e.g. 16 shops with $ 6 800 000 of revenues with $ 35 000 of net profit per shop. Is there a way to put it into one chart? the number of shops will be almost an invisible bar while revenues will sky rocket - with such a chart (though precise) it would be difficult to illustrate the market conditions in the range of say, 3 years. Or to put it in plain English: I want to see the relationship between apples, pears,phonecall , flowers and rainfall though they would show a different values since they are measured in different units ( $, kg, m3, hours). |
#2
|
|||
|
|||
Hi Bas,
you could at least use the second y-axis to divide the two very extremely diverging data ranges... (right-click and use data options) but afaik you cannot use more than two y- axis - so I would assume that you divide some of the ranges by 1000 or 1000000 and set a text box within the chart where you write "in M kg" "in B $" and so on... Best Markus -----Original Message----- I want to create a simple (bar) chart where there would be sales compared with number of shops compare with sales of chocolate compared with net profit/shop Of course such a chart would look terrible since the it would compare e.g. 16 shops with $ 6 800 000 of revenues with $ 35 000 of net profit per shop. Is there a way to put it into one chart? the number of shops will be almost an invisible bar while revenues will sky rocket - with such a chart (though precise) it would be difficult to illustrate the market conditions in the range of say, 3 years. Or to put it in plain English: I want to see the relationship between apples, pears,phonecall , flowers and rainfall though they would show a different values since they are measured in different units ( $, kg, m3, hours). . |
#3
|
|||
|
|||
Want a tertiary axis to go with primary and secondary? Try this:
http://peltiertech.com/Excel/Charts/TertiaryAxis.html I had a project recently that actually went to Quaternary axes (that's 4, count 'em) using this technique. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Bas Avel wrote: I want to create a simple (bar) chart where there would be sales compared with number of shops compare with sales of chocolate compared with net profit/shop Of course such a chart would look terrible since the it would compare e.g. 16 shops with $ 6 800 000 of revenues with $ 35 000 of net profit per shop. Is there a way to put it into one chart? the number of shops will be almost an invisible bar while revenues will sky rocket - with such a chart (though precise) it would be difficult to illustrate the market conditions in the range of say, 3 years. Or to put it in plain English: I want to see the relationship between apples, pears,phonecall , flowers and rainfall though they would show a different values since they are measured in different units ( $, kg, m3, hours). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Data between two sheets | Excel Worksheet Functions | |||
Comparing Data in 2 columns | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Formula for comparing text in two workbooks | Excel Worksheet Functions | |||
Comparing Data in two columns | Excel Worksheet Functions |