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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
"likes2cook" wrote in message
...
I am sorry but I am confused. What do you mean by "Select the series, and
don't bring up the Data Source dialog"? Is this the same as highlighting
the
chart?