Search and replace option in graphs

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Thanks, will Try the same

Andy Pope said:
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
Click to expand...
 
I have a little utility for editing series formulas:

http://peltiertech.com/Excel/Charts/ChgSrsFmla.html
Click to expand...

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.
 
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 said:
I have a little utility for editing series formulas:

http://peltiertech.com/Excel/Charts/ChgSrsFmla.html
Click to expand...


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.
Click to expand...
 
Back
Top