Using an area chart to show survey responses as two series with four data points in each. The x-axis are the four answer choices, the y axis is the percentage of respondents.

The problem is the data on the second series is graphically exaggerated, the largest data point is 75% (reflected in the labels if I turn them on) but looking at the y axis and corresponding gridlines, it is charted as around 125%. that is only for the second of the 2 series, that first is accurate.

  • Have you checked each axis min/max values? Likely they're different, causing the discrepancy. Go into their format sections and set each manually-don't keep the auto setting. – dav Jun 2 '14 at 22:11

Sounds like you are using a Stacked Area Chart. Change the chart type to "Area Chart"

enter image description here

  • To avoid confusion, you should probably use a line chart rather than an area chart. – Jon Peltier Jul 10 '15 at 15:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.