Re: chart data range too complex

[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

 

[Jon Peltier]

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

 

[Jon Peltier]

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