ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Change multiple Chart Titles in different sheets in the same Workbook (https://www.excelbanter.com/excel-worksheet-functions/266861-change-multiple-chart-titles-different-sheets-same-workbook.html)

asprivl

Change multiple Chart Titles in different sheets in the same Workbook
 
Hello

I have about 100 diffrent charts (in one Workbook devided in 100 sheets) but they have the same chart title which is IN the chart and if I want to edit it I become the usual excel square where I can write into it.

Do I have to enter in EACH sheet everytime (100 times) to change this chart title with f.ex. copy and paste?

Is there any other way to do that faster?

Thank you very much

Excel level : medium

wickedchew

Quote:

Originally Posted by asprivl (Post 960664)
Hello

I have about 100 diffrent charts (in one Workbook devided in 100 sheets) but they have the same chart title which is IN the chart and if I want to edit it I become the usual excel square where I can write into it.

Do I have to enter in EACH sheet everytime (100 times) to change this chart title with f.ex. copy and paste?

Is there any other way to do that faster?

Thank you very much

Excel level : medium

Found this in another forum.
http://www.eggheadcafe.com/software/...art-title.aspx

lauratristin

I got this same thing from the other website. It is very nice as well as very good details about it. Excel is one of the best applications for creating chart in different views, tools, different shapes and attractive colours.


All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com