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.

--
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

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