Hello all:
I am running Excel '02.

I've been trying to use the information on Jon Peltier's website as it
relates to updating embedded charts using his Macros and "chart series
Formula." However, I have continuously failed when I try to view the "chart
series" in the formula bar. In some of the examples on his web page
(Http://peltiertech.com/Excel/Charts/ChgSrsFmla.html ) the "chart series" is
visable in the formula bar.

I must be missing something? Help please?

Thanks in advance for any help!

Mike

Is the formula bar visible? If not, go to Tools menu Options View tab,
check the Formula Bar box in the top row of boxes.

Have you selected a series? Single click right on the plotted series.

Version shouldn't matter. It's worked as long as I can remember (before '97,
probably before 5/95), and aside from some monkey business during the 2007
Beta, it works in 2007.

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


"Spidey" wrote in message
...
Hello all:
I am running Excel '02.

I've been trying to use the information on Jon Peltier's website as it
relates to updating embedded charts using his Macros and "chart series
Formula." However, I have continuously failed when I try to view the
"chart
series" in the formula bar. In some of the examples on his web page
(Http://peltiertech.com/Excel/Charts/ChgSrsFmla.html ) the "chart series"
is
visable in the formula bar.

I must be missing something? Help please?

Thanks in advance for any help!

Mike

The 'man' himself! As usual...user error. I was selecting everything on the
chart (except what I need to), and I was looking for the 'series formula'
within source data wizard. I ran your Macro's and the work great! Both I
and my fingers thank you, as I have a good deal of updating to do.

Thanks,
Again

"Jon Peltier" wrote:

Is the formula bar visible? If not, go to Tools menu Options View tab,
check the Formula Bar box in the top row of boxes.

Have you selected a series? Single click right on the plotted series.

Version shouldn't matter. It's worked as long as I can remember (before '97,
probably before 5/95), and aside from some monkey business during the 2007
Beta, it works in 2007.

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


"Spidey" wrote in message
...
Hello all:
I am running Excel '02.

I've been trying to use the information on Jon Peltier's website as it
relates to updating embedded charts using his Macros and "chart series
Formula." However, I have continuously failed when I try to view the
"chart
series" in the formula bar. In some of the examples on his web page
(Http://peltiertech.com/Excel/Charts/ChgSrsFmla.html ) the "chart series"
is
visable in the formula bar.

I must be missing something? Help please?

Thanks in advance for any help!

Mike