Worksheet cell info to chart
 

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

Worksheet cell info to chart
 

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.

--
Thanks,
Shane Devenshire


"Noreaster" wrote:

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

Worksheet cell info to chart
 

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.

"ShaneDevenshire" wrote:

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.

--
Thanks,
Shane Devenshire


"Noreaster" wrote:

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