| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Referencing chart sheets in vba
I asked this question in the programming forum but got no replies, so I'll
try it here. I'm trying to adapt some code (from Jon Peltier's website) to scale chart axes based on cell contents. I can get the code to work for charts embedded in the active worksheet and other worksheets, but I can't figure out how to reference a chart that is on it's own sheet. How is this done? Here is the type of code I'm working with: ActiveSheet.ChartObjects("Chart 1").Chart.Axes(xlCategory) _ .MaximumScale = Target.Value Can anyone help me? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Referencing chart sheets in vba
Never mind. i figured it out. You have to use the CHARTS property.
"The Big Smelly Ogre" wrote: I asked this question in the programming forum but got no replies, so I'll try it here. I'm trying to adapt some code (from Jon Peltier's website) to scale chart axes based on cell contents. I can get the code to work for charts embedded in the active worksheet and other worksheets, but I can't figure out how to reference a chart that is on it's own sheet. How is this done? Here is the type of code I'm working with: ActiveSheet.ChartObjects("Chart 1").Chart.Axes(xlCategory) _ .MaximumScale = Target.Value Can anyone help me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to deselect a selected chart programatically? | Charts and Charting in Excel | |||
| chart to consolidate similar sheets files | Charts and Charting in Excel | |||
| Chart Property Confusion | Charts and Charting in Excel | |||
| tick mark labels | Charts and Charting in Excel | |||
| Referencing Sheets in a Formula | Excel Discussion (Misc queries) | |||
Linear Mode
