Worksheet cell info to chart

  • Thread starter Thread starter Noreaster
  • Start date Start date
N

Noreaster

After the line chart gets its info, I have to edit the header each time to
show the correct product number. Can it be done so that say B1 has 1148, I
would it to show at the top of the line chart automatically?
Could I also choose the font size?

TIA
 
Hi,

When you say "header" do you mean the chart title? If so single click the
chart title and type = then click on the cell containing the product number
and press Enter. The chart will use the entry in the cell for the chart
title.
 
Thats it. Thank you so very much :-)
There's so much info in these newsgroups that I'm trying to go thru since
someone asked me if I can do charts. All I have done up to that point was
simple math, so to speak, in excel. I'm trying to learn with 1 active brain
cell thats a little slow at times.

Thank you all that have helped.
 
You must log in or register to reply here.

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

How to chart months by financial year 0
Macro to change position of chart labels on line chart 1
Chart SERIES OFFSET 3
Chart Relative To Worksheet When Copying- Excel 2007 1
How to show chart only within worksheet? 4
Odd Chart Format Results 1
How to hide a chart title, but keep the title in the chart 1
link a chart source to a cell reference 3

Back
Top