Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default Why does Excel line chart cut off my data series?

This does not happen with other chart forms, including radar. I am trying to
create a 3 series chart with data points for each day over a 3 week period.
Sometimes get the message that chart can only use 32000 data points, but this
is well under that limit. This has not happened before. What is going
wrong? (...or what am I doing wrong?) Not a stranger to Excel, though not a
power user, but never had this problem before.

Will reinstall the program as soon as I find the disk (just moved office).
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Why does Excel line chart cut off my data series?

You haven't described what you mean by "cut off".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"snowbound" wrote in message
...
This does not happen with other chart forms, including radar. I am trying
to
create a 3 series chart with data points for each day over a 3 week
period.
Sometimes get the message that chart can only use 32000 data points, but
this
is well under that limit. This has not happened before. What is going
wrong? (...or what am I doing wrong?) Not a stranger to Excel, though not
a
power user, but never had this problem before.

Will reinstall the program as soon as I find the disk (just moved office).



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default Why does Excel line chart cut off my data series?

The data series will show up to a certain point, then stops. In this case,
it stops at day 12, though there are 21 days of data. The chart is complete
in other respects (ie, the x and y axes both extend to the desired values).
The data sets will display all 21 days in other chart forms.

I hope this is the information you were looking for

"Jon Peltier" wrote:

You haven't described what you mean by "cut off".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"snowbound" wrote in message
...
This does not happen with other chart forms, including radar. I am trying
to
create a 3 series chart with data points for each day over a 3 week
period.
Sometimes get the message that chart can only use 32000 data points, but
this
is well under that limit. This has not happened before. What is going
wrong? (...or what am I doing wrong?) Not a stranger to Excel, though not
a
power user, but never had this problem before.

Will reinstall the program as soon as I find the disk (just moved office).




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Why does Excel line chart cut off my data series?

Go to Source Data on the Chart menu. Click on the Series tab. Select the
"cut off" series. Are the complete ranges shown in the X values and Y values
boxes?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"snowbound" wrote in message
...
The data series will show up to a certain point, then stops. In this
case,
it stops at day 12, though there are 21 days of data. The chart is
complete
in other respects (ie, the x and y axes both extend to the desired
values).
The data sets will display all 21 days in other chart forms.

I hope this is the information you were looking for

"Jon Peltier" wrote:

You haven't described what you mean by "cut off".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"snowbound" wrote in message
...
This does not happen with other chart forms, including radar. I am
trying
to
create a 3 series chart with data points for each day over a 3 week
period.
Sometimes get the message that chart can only use 32000 data points,
but
this
is well under that limit. This has not happened before. What is going
wrong? (...or what am I doing wrong?) Not a stranger to Excel, though
not
a
power user, but never had this problem before.

Will reinstall the program as soon as I find the disk (just moved
office).






  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default Why does Excel line chart cut off my data series?

I am assuming you mean value ranges. Yes. This was one of the first things
I checked. Also checked data range. Still getting message that 2D charts
are limited to 32000 data points. Am nowhere close to that! I have tried
recreating chart several times with similar results. BAffled.

"Jon Peltier" wrote:

Go to Source Data on the Chart menu. Click on the Series tab. Select the
"cut off" series. Are the complete ranges shown in the X values and Y values
boxes?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"snowbound" wrote in message
...
The data series will show up to a certain point, then stops. In this
case,
it stops at day 12, though there are 21 days of data. The chart is
complete
in other respects (ie, the x and y axes both extend to the desired
values).
The data sets will display all 21 days in other chart forms.

I hope this is the information you were looking for

"Jon Peltier" wrote:

You haven't described what you mean by "cut off".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"snowbound" wrote in message
...
This does not happen with other chart forms, including radar. I am
trying
to
create a 3 series chart with data points for each day over a 3 week
period.
Sometimes get the message that chart can only use 32000 data points,
but
this
is well under that limit. This has not happened before. What is going
wrong? (...or what am I doing wrong?) Not a stranger to Excel, though
not
a
power user, but never had this problem before.

Will reinstall the program as soon as I find the disk (just moved
office).






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't get data from a web page to chart in excel. Any solutions? goody444 Charts and Charting in Excel 1 March 1st 06 01:23 PM
Can't get data from a web page to chart in excel. Any solutions? goody444 Excel Discussion (Misc queries) 1 March 1st 06 06:09 AM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Formatting lines between data points in a line chart ltanner Charts and Charting in Excel 2 March 13th 05 05:12 AM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 03:30 AM


All times are GMT +1. The time now is 02:11 AM.

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

About Us

"It's about Microsoft Excel"