Posted to microsoft.public.excel.programming

The Big Smelly Ogre The Big Smelly Ogre is offline

external usenet poster

Posts: 1

Referencing a chart sheet

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sheet Referencing - autofilling sheet names	Pat	Excel Worksheet Functions	2	June 4th 09 03:50 AM
chart referencing	Anto111	Excel Discussion (Misc queries)	0	July 15th 08 05:29 PM
copy formula referencing sheet name to another sheet	Tat	Excel Worksheet Functions	1	June 26th 05 03:00 AM
referencing a sheet named in a cell then using data from that sheet	gbeard	Excel Worksheet Functions	4	April 15th 05 08:42 AM
referencing another sheet	James[_22_]	Excel Programming	5	April 9th 04 10:16 PM

All times are GMT +1. The time now is 12:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us