Chart title with text and range.value

D

Diogomg

New Member
Joined
May 14, 2013
Messages
30
Hello,

Is it possible to create a chart title with text and range value?

I tried

ActiveChart.ChartTitle.Text = "Chart " & Worksheets("BANCO DE DADOS CL").Range("BJ1").Value

but didn't work out




Thank You
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Sort by date Sort by votes
Hi - I don't think this is possible.

Best to put that formula in a helper cell and refer to that cell in the chart title.

Dean.
 
Upvote 0
Sorry just realised you were doing this in VBA. Thought you were directly linking a chart title in the worksheet.

This worked fine for me in VBA. Do you have the chart actually selected when you run it?

Dean.
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

awoohaw
  • Question
Treemap Chart Title
Replies
1
Views
184
kevin9999
K
J
  • Question
VBA Clear Chart Dynamically and refresh with new values
2
Replies
10
Views
812
Jon Peltier
J
O
  • Solved
How to specify the chart title (caption) and y axis label or an embedded chart in VBA?
Replies
7
Views
276
Domenic
D
B
  • Solved
Macro to list out chart names into a sheet column
2
Replies
10
Views
360
BuJay
B
B
  • Question
How do I export charts based on conditions to PDF using VBA?
Replies
1
Views
127
John_w
J

Forum statistics

Threads
1,203,099
Messages
6,053,527
Members
444,669
Latest member
Renarian

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top