ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Not all my data is showing up in my chart... (https://www.excelbanter.com/charts-charting-excel/158014-not-all-my-data-showing-up-my-chart.html)

Jordlaw

Not all my data is showing up in my chart...
 
I highlight all the data I want to plot in the XY Scatter chart (8 rows of
data) Only 7 rows are plotted though. There are no formulas or anything.
Can someone please help me.

David Biddulph[_2_]

Not all my data is showing up in my chart...
 
What does in show under "Source Data" for the chart?
My guess is that it may have taken the first row of data and used that as
the X values. The usual advice from Jon Peltier (the charting guru) is that
you leave the top-left hand corner cell empty, so that Excel recognises the
first row (if your data is in rows) as X values, and also recognises the
first column as series labels.
Even if you haven't got the right default behaviour when you created your
chart, you can edit the Source Data (including adding an extra series if you
need to do so).
--
David Biddulph

"Jordlaw" wrote in message
...
I highlight all the data I want to plot in the XY Scatter chart (8 rows of
data) Only 7 rows are plotted though. There are no formulas or anything.
Can someone please help me.





All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com