If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Overlap graph multiple axis
Hi,
I am aware of secondary axis. But is it possible to plot more than 2 types of data? So, for example I want to plot over time (so week1, week 2, etc = x-axis). and on the y-axis I want to plot firstly the volume of a particular product sold. Secondly the weekly price it has been sold at, thirdly the margin per item and also a percentage of this product as overall number against all types of this product. This is because all these items will tell the full story of what is happening and how sales are impacted. Is it possible to have more than 2 y axis? or somehow 'overlap' different graphs? Thanks. |
#2
|
|||
|
|||
Overlap graph multiple axis
Check out the Excel help pages under Combination Charts and also Secondary
Axis. I think that maybe plotting so many things on your chart could make it confusing, not least in trying to read the values off the y axes and that the values have different units (volume, price, margin & %) - although maybe price and margin could be combined on one y axis and either volume or % on the other. Give it a go and see how it looks. Regards, Tom "aquaxander" wrote: Hi, I am aware of secondary axis. But is it possible to plot more than 2 types of data? So, for example I want to plot over time (so week1, week 2, etc = x-axis). and on the y-axis I want to plot firstly the volume of a particular product sold. Secondly the weekly price it has been sold at, thirdly the margin per item and also a percentage of this product as overall number against all types of this product. This is because all these items will tell the full story of what is happening and how sales are impacted. Is it possible to have more than 2 y axis? or somehow 'overlap' different graphs? Thanks. |
Thread Tools | |
Display Modes | |
|
|