add extra label to chart based on dropdown box

[Bobbrown]

Hope I am asking this question in the right forum and apologies if there is an obvious answer that I have missed but don’t do a lot of charting.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I have a chart that makes up part of a dashboard. It displays Investment attracted against target (KPI). The data is cumulative and I need to add a label that links to a drop down list that the person inputting the data can select to identify the reporting period. This label will then display in the chart saying something like reporting date to ‘June 2011’ (taken form the drop down). I have done the dropdown list in the data sheet but cant figure how to add it to the chart in the chart sheet.
Any assistance would be appreciated.<o></o>

 

[VoG]

This may help you http://www.appspro.com/Utilities/ChartLabeler.htm

 

[Bobbrown]

Thanks VoG.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I sit behind a network with no administrator rights so cant install anything and from previous experience our IT guys aren’t interested in anything that’s not standard issue. Thanks for your promt reply anyway.<o></o>

 

[VoG]

Maybe change the chart title like this

Sub ChLabel()
With ActiveSheet.ChartObjects("Chart 1").Chart
    .HasTitle = True
    .ChartTitle.Text = Range("C1").Value
End With
End Sub

 

[Bobbrown]

Thanks VoG
Tried the marco but returned and error.
Run-time error 1004
"Unable to get the chartObjects of the worksheet class"
I not all that good at VBA so it might be something I am doing wrong.

 

[VoG]

You will need to change Chart 1 to the actual name of the chart.

 

[Bobbrown]

Thanks VoG<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Apologies for the delayed response but been enjoying a bit of R &R and been offline.<o></o>
Couldn’t get the macro to work so tried another option. <o></o>
As this is something I will only do once a month and I finish up doing a fair bit of work after hours from home I decided to install XY Labeller on my machine at home and work around it that way. Thanks again for the tip.<o></o>
<o></o>
TB.<o></o>

 

[Steve=True]

If this is in the Chart Title, you can add the chart title, then go to the formula bar type = and the cell that points to the dropdown box value.

If it is not a Chart Title, what type of chart are you using?

Steve=True
www.exceldashboardtemplates.com