Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract Chart Titles from graphs
I am looping through some chars in a workbook. I am trying to extract the
text from the Chart Titles. I cannot seem to get this to work using the ChartTitle object and its Caption property. What am I doing wrong? Dim chtobj As ChartObject For Each chtobj In ActiveSheet.ChartObjects Debug.Print chtobj.ChartTitle.Caption Next Thanks EM |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extract Chart Titles from graphs
Try this
Sub Test() Dim chtobj As Excel.ChartObject For Each chtobj In ActiveSheet.ChartObjects If chtobj.Chart.HasTitle Then Debug.Print chtobj.Chart.ChartTitle.Text End If Next chtobj End Sub HTH, Barb Reinhardt "Excel Monkey" wrote: I am looping through some chars in a workbook. I am trying to extract the text from the Chart Titles. I cannot seem to get this to work using the ChartTitle object and its Caption property. What am I doing wrong? Dim chtobj As ChartObject For Each chtobj In ActiveSheet.ChartObjects Debug.Print chtobj.ChartTitle.Caption Next Thanks EM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
expanding titles on graphs | Charts and Charting in Excel | |||
axes titles in excel graphs | Charts and Charting in Excel | |||
Extract Data Validation Input Messages and Titles | Excel Programming | |||
URGENT - NEED EXCEL PROGRAMMER - AUTOMATE THE TITLES IN MY EXCEL GRAPHS | Excel Programming | |||
HOW TO PROGRAM EXCEL SO THAT THE TITLES ON GRAPHS ARE AUTOMATICALLY CHANGED | Excel Programming |