Cell description into the chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I put the information written in the cell D15 of the "sheet1" into
the chart 1 created as new sheet (chart1). I want to put this nformation as a
label on the top of the chart.

Thanks in advance.
Maperalia
 
Place the following in your code:
With ActiveChart
.HasTitle = True
'''substitute the following range for the range that
'''contains the label for the chart
.ChartTitle.Characters.Text = Sheets("Sheet1").Range("A1").Value
end with

Hope that helps
JNW
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to determine chart name 5
Excel 2007 Chart Colors 3
Change text in Textbox on Chart? 3
Create several charts in one go using VBA 4
Using VBA to copy a Chartsheet to Powerpoint 2
Charts with Combobox 2
How to add series to a chart using a macro 12
Subaddress for a chart in Excel 2

Back
Top