excel - Vertical Axis Values vs. Secondary Data Series Values -
i have simple "stacked line markers" chart type 3 columns of data; month, preventable incidents , non-preventable incidents. chart looks @ 6 months of data , charts preventable , non-preventable incidents. have months along horizontal axis (column a: a2:a7) number of collisions on vertical axis. preventable incident values in column b: b2:b7 , non-preventable incident values in column c: c2:c7.
the preventable values data points on chart correspond correctly vertical axis labels, non-preventable data points skewed higher , not correspond correctly vertical axis labels. appreciate in understanding why case , there way have both data series plot correctly values in vertical axis labels.
probably need use "line markers" instead of "stacked line". stacked line plot sum of series can see additive effect of both. doesn't if want exact values both series.
Comments
Post a Comment