Re: chart data range too complex

  • Thread starter Thread starter Jon Peltier
  • Start date Start date
J

Jon Peltier

Look at the series tab. It lists the ranges for each series, so you can edit
these ranges (series by series, so it's not as fast as doing the whole chart
at once). When you select a series, you can see the data for that series
outlined with green, blue, and purple. These rectangles can be moved and
sized to change the source data.

A small subset of the reasons the range may be "too complicated" to display:

1. The series are not all the same length.
2. The ranges are not all parallel (i.e., one series uses some data plotted
by columns, another series uses some by rows).
3. Each series plots data from different sheets.

- Jon
 
Select the series, and don't bring up the Data Source dialog. Do you see the
ranges highlighted with colored rectangles?

Select the series and look in the formula bar. Copy the formula you see and
paste it into a reply to this message.

- Jon
 
A set of plotted points is called a series. Select a set of plotted points,
that is, select a series. Do this by clicking on a plotted point, which may
be a marker or a column or bar. Now you should see a formula in the formula
bar, which will resemble this:

=SERIES(Sheet1!$B$1,Sheet1!$A$2:$A$10,Sheet1!$B$2:$B$10,1)

You may also see colored rectangles highlighting the series data in the
worksheet. You may not if the data range is scrolled out of sight or if it
resides on a different sheet.

- Jon
 
Back
Top