arobbins10
New Member
This is sort of a difficult question to type out here, so it might be easier to just check my attachment as I included charts with examples of what I'm trying to do.
Basically, I have a set of data that will be updating frequently: 5 products, Absolute $ Change, and % $ Change. I want Absolute $ Change displayed as a bar, and % Change displayed as a line - so the user can see, in one glance, if by how much volume went up or down, and what is this as a %.
The issue is, when putting the % change on the secondary axis and changing to a line chart, the chart doesn't hold 0% as being in line with 0 on the primary axis. E.g., 0% might be set to halfway up the secondary axis, so a -10% is above the line for the labels, so to the user it looks like there was positive % growth (when hiding the axis from view). I want 0% to be "planted" right at the 0 line for the primary axis - i.e. right in line with the labels. So a negative % change will be below this line, and all positive % changes go above.
The only way I've found to do the above is to manually change the secondary axis so that the min/max ratio is the same as the primary axis. E.g., if the primary axis min/max is -50 and 300, the secondary axis needs to be changed to -2 and 12, maintaining the -1:6 ratio.
This won't work because the data will be updated every week or so, and there will be at least a dozen of these charts, so I would have to go in an manually change the secondary axis each time to match the new ratio of the primary axis.
Hopefully that makes sense - and I'm 100% open to suggestions or even improvements on how to display this data. The important things are: 1) the chart needs to update automatically and correctly display the data with each change to the raw data, and 2) in one chart, be able to quickly and intuitively convey Absolute $ Change and % Change.
Thanks for any and all help!
Basically, I have a set of data that will be updating frequently: 5 products, Absolute $ Change, and % $ Change. I want Absolute $ Change displayed as a bar, and % Change displayed as a line - so the user can see, in one glance, if by how much volume went up or down, and what is this as a %.
The issue is, when putting the % change on the secondary axis and changing to a line chart, the chart doesn't hold 0% as being in line with 0 on the primary axis. E.g., 0% might be set to halfway up the secondary axis, so a -10% is above the line for the labels, so to the user it looks like there was positive % growth (when hiding the axis from view). I want 0% to be "planted" right at the 0 line for the primary axis - i.e. right in line with the labels. So a negative % change will be below this line, and all positive % changes go above.
The only way I've found to do the above is to manually change the secondary axis so that the min/max ratio is the same as the primary axis. E.g., if the primary axis min/max is -50 and 300, the secondary axis needs to be changed to -2 and 12, maintaining the -1:6 ratio.
This won't work because the data will be updated every week or so, and there will be at least a dozen of these charts, so I would have to go in an manually change the secondary axis each time to match the new ratio of the primary axis.
Hopefully that makes sense - and I'm 100% open to suggestions or even improvements on how to display this data. The important things are: 1) the chart needs to update automatically and correctly display the data with each change to the raw data, and 2) in one chart, be able to quickly and intuitively convey Absolute $ Change and % Change.
Thanks for any and all help!