Adding NonAdjacent Data to a Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Whenever I enter new, nonadjacent (columns are separated) to a chart they do
not show up, Is this a bug or is there a maximum number of data points to a
chart?
 
How are you adding the data?

If that's not the problem: Do you have discontiguous X and Y value ranges with many
unconnected points? There is a limit to how long the definition of each can be
(i.e., the number of characters each uses in the series formula). If empty columns
are used for arrangement of the data, you should break the habit of using empty rows
and columns for formatting. If it's due to a particular data arrangement, you could
consider compiling the data in another worksheet range, without blanks, using links
so the chart updates with changing data.

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