Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
seeing the Chart Series Formula
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
seeing the Chart Series Formula
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
seeing the Chart Series Formula
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How To: Easy Box Plot | Charts and Charting in Excel | |||
Chart series (based on datarange content) | Excel Discussion (Misc queries) | |||
Chart series | Charts and Charting in Excel | |||
"Unable to set the Formula property of the Series class" with a tw | Charts and Charting in Excel | |||
How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) |