• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 385
  • Last Modified:

Excel chart plotting incorrectly

I've been working on a simple line chart and for some reason plot points are showing higher on their axis than they should be.  As you'll see, a point with a value of 90 is showing up at about 125-130 on the axis.  I'm not sure why this is happening, and nothing I do to try and manipulate it helps to correct it

Any thoughts?

Bad plotting
  • 2
1 Solution
Harry LeeCommented:
pmcinc, you have picked the wrong chart type.

You are currently using the stacked line chart.

You have to change the line chart type back to line.

You can do it by Right-Click on the chart, and choose Change Chart Type. Pick Line on the left pane, and pick the first line chart type on the right pane.
Harry LeeCommented:
When you look at your uploaded picture, your Orange line is basically plotted at CO-937 value plus CO-928 value, while the Grey line is plotted at CO-937 value plus CO-928 value plus BZ-FG value.
pmcincAuthor Commented:
Yep, turned out I selected the wrong type.  Thanks for pointing that out.  :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now