Referencing a chart sheet

  • Thread starter The Big Smelly Ogre
  • Start date
T

The Big Smelly Ogre

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Touble with Dynamix Axis Scales via a Cell Value 3
Macro to determine chart name 5
how to add error bars into bar chart 1
Axes(xlCategory) for a chart-sheet in 2007 2
Referencing chart sheets in vba 1
Scaling Graphs 9
Chart label alignment 0
error with chart object 1

Top