Link to home
Create AccountLog in
Avatar of coachjim
coachjimFlag for Gabon

asked on

Goofy graph in Excel

I've got a spreadsheet in Excel.  I've created a graph from the data.  All the data is formatted as numbers.

When you look at the data labels the numbers for the lowest line match the scale of the axis.  Thus if you look at the dark blue line, the data range from 6.4 for the first data point to 6.7 for the last.  It looks like those match the axis.

The next data line in a rust color shows a first data point of 21.5 and a final one of 11.2.  In that line, you see a number of data points with values below 15 showing up above the 20 mark on the axis.

It gets worse from there with the final data line, the top one (in goldenrod) showing data that range from 13 for the first point to 14 for the last one and nearly all are above the 80 mark on the axis.

What gives?  Below are images of both the data and the graph.

User generated image
User generated image
Avatar of byundt
byundt
Flag of United States of America image

Could you please post the workbook?

I'd like to verify that the data is coming from the cells you say and that the data labels represent the current data (as opposed to old data). I'd also like to make sure that the data aren't being plotted against an invisible secondary y-axis.
Avatar of coachjim

ASKER

The workbook is attached.
Icon-Auto-Data-Summary.xlsx
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
I've been using spreadsheets since '82 and have never needed to understand what a stacked graph was.  I probably used one correctly by accident at some point.

Anyway, awesome help.  Thank you.