Hi Rick,

If its the x-axis label the easiest solution is to create the charts
initially with the label referencing a spreadsheet cell rather than being
hard coded. When you want to update all the labels you would just change the
entry in the cell. All charts would use the same cell reference.

How to reference a cell from a Title, label, or text box on a chart:
Click the item once, type = and then click on the cell where the text entry
is. Then press Enter.

You can also do mass updates via VBA - you would need to write code.

Cheers,
Shane Devenshire


"Rick" wrote:

Hi
I have had occasion to make spreadsheets with 30 or more charts. I have
needed to make the same change on all the charts, such as changing the x-axis
label. Is there a way to do that all at once (all changed to the same thing)
or must I tediously change each one at a time? Thanks