On Fri, 11 Aug 2006, in microsoft.public.excel.charting,
Jon Peltier said:

"Mr. DP" <Mr. wrote
Is there any way to use Search and replace options in case of Graphs and
Charts.

I have a little utility for editing series formulas:

http://peltiertech.com/Excel/Charts/ChgSrsFmla.html

Something I have often wished for is a form-based VBA helper macro that
would show me all the relevant features of the series in a complicated
combination graph, so I could keep it all straight in my head. What
usually happens is I lose track of what axes the series are on, and
which order, which chart type, and so on.

My ideal, if I had the VBA skills, would be a form that looked like
this:

[SeriesName] [XValues] [YValues] [PlotOrder] [XAxis] [Yaxis] [Type]
----------------- ------------ ------------
-------------- -------- -------- --------
[First Bar] [A1:A99] [B1:B99] [1] Up [1] [1] [Bar]
[Another] [A1:A99] [C1:C99] [2] ^ [1] [1] [Bar]
[YetAnother] [A1:A99] [D1:D99] [3] | [1] [1] [Bar]
[Line1] [E1:E99] [F1:F99] [4] V [2] [2] [Line]
[RedLine] [E1:E99] [G1:G99] [5] Down [2] [2] [Line]

The Plot Order control would move the series up and down the plot orders
(though possibly not outside the allowed type range unless the type was
changed).

Most times I wonder what's going wrong with a combination graph I
designed, it's because I can't see at a a glance where all the series
are in relation to each other.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.