Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 7
Default Bulk insert of chart titles?

I have several worksheets in a workbook, the layout on each worksheet is the
same as the others, and each sheet has a chart, displaying charts of the
data in each worksheet.
I am able to insert chart titles into each chart, one at a time, but would
like to do this as a single operation, in other words is there any way that
I can insert a title in each chart referencing the same cell in each
worksheet, in one operation?


  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Bulk insert of chart titles?

Stan -

You need a little macro to do what you want. This loops through every
worksheet in the active workbook, and for every chart on the worksheet, it
adds a title that is linked to cell A1 of that worksheet.

Sub InsertChartTitles()
Dim chtob As ChartObject
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
For Each chtob In ws.ChartObjects
With chtob.Chart
.HasTitle = True
.ChartTitle.Text = "=Sheet1!R1C1"
End With
Next
Next
End Sub

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


"SouthAfricanStan" <me@there wrote in message
...
I have several worksheets in a workbook, the layout on each worksheet is
the same as the others, and each sheet has a chart, displaying charts of
the data in each worksheet.
I am able to insert chart titles into each chart, one at a time, but would
like to do this as a single operation, in other words is there any way
that I can insert a title in each chart referencing the same cell in each
worksheet, in one operation?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel chart options titles tab should allow copy paste in fields belohls Charts and Charting in Excel 2 August 11th 06 03:15 PM
Sorting values in a bar chart Eric D Charts and Charting in Excel 4 April 17th 06 04:44 PM
How do I insert column titles? Anne V. Setting up and Configuration of Excel 1 November 4th 05 11:24 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 11:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"