Search and replace option in graphs

[Mr. DP]

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

 

[Andy Pope]

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]

Thanks, will Try the same

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

 

[Jon Peltier]

I have a little utility for editing series formulas:

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

- Jon

 

[Del Cotter]

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] [D199] [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]

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

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] [D199] [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.