A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Charts and Charting in Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Not all my data is showing up in my chart...



 
 
Thread Tools Display Modes
  #1  
Old September 12th 07, 02:00 PM posted to microsoft.public.excel.charting
Jordlaw
external usenet poster
 
Posts: 2
Default 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.
Ads
  #2  
Old September 12th 07, 08:50 PM posted to microsoft.public.excel.charting
David Biddulph[_2_]
external usenet poster
 
Posts: 8,651
Default 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.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with data showing on chart Jamie Charts and Charting in Excel 0 March 14th 07 12:51 PM
Bar Chart with bar data and another bar showing a range of data DQuint Charts and Charting in Excel 2 September 7th 06 04:44 PM
Data showing incorrectly on line chart gobonniego Charts and Charting in Excel 1 June 15th 06 07:56 PM
Data showing incorrectly on line chart gobonniego Charts and Charting in Excel 1 June 7th 06 09:27 AM
Data not showing on my chart kalyhan Charts and Charting in Excel 6 May 3rd 05 10:03 PM


All times are GMT +1. The time now is 04:31 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.