Search and replace option in graphs
 

Is there any way to use Search and replace options in case of Graphs and
Charts.

Search and replace option in graphs
 

Hi,

I don't believe so. You would need to write VBA code to do this for the
textual elements of a chart, such as titles.
For linked elements like category labels and data labels you will need
to change the actual cell contents.

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Search and replace option in graphs
 

Thanks, will Try the same

"Andy Pope" wrote:

Hi,

I don't believe so. You would need to write VBA code to do this for the
textual elements of a chart, such as titles.
For linked elements like category labels and data labels you will need
to change the actual cell contents.

Cheers
Andy

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Search and replace option in graphs
 

I have a little utility for editing series formulas:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


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

Wishlist: graph design wizard
 

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.

Wishlist: graph design wizard
 

Hi,

Whilst not a userform John Walkenbach's ChartTools addin does have a
report option.
http://j-walk.com/ss/excel/files/charttools.htm

Cheers
Andy

Del Cotter wrote:
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.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info