Hello all,

Is there a way to link a chart to a cell on a spreadsheet that contains the
date? What I want to do is generate weekly charts on production data, and
pick up the date that's put in a cell and display it either in the chart
title or near it.
Can that be done?

Thanks,
Brian

You can use a shape from the drawing toolbarselect itin the formula box
type in =$d$18 if cell d18 contains the date

--
Don Guillett
SalesAid Software

"diablo" wrote in message
...
Hello all,

Is there a way to link a chart to a cell on a spreadsheet that contains
the date? What I want to do is generate weekly charts on production data,
and pick up the date that's put in a cell and display it either in the
chart title or near it.
Can that be done?

Thanks,
Brian

"Don Guillett" wrote in message
...
You can use a shape from the drawing toolbarselect itin the formula box
type in =$d$18 if cell d18 contains the date

--
Don Guillett
SalesAid Software

"diablo" wrote in message
...

I tried what you suggest but I only see what I typed, =$g$1 which is the
cell that contains the date. I used a rectangle shape. I had tried this
already with a text box as well, it didn't work either.

Thanks,
Brian

--

diablo:

You can link cell contents to your chart. This link shows you how to make a
dynamic title that is linked to a cell.

http://processtrends.com/pg_chart_dy...hart_title.htm

Kelly




"diablo" wrote in message
...
Hello all,

Is there a way to link a chart to a cell on a spreadsheet that contains
the date? What I want to do is generate weekly charts on production data,
and pick up the date that's put in a cell and display it either in the
chart title or near it.
Can that be done?

Thanks,
Brian

Hi,

Explanation with respect to the chart title, but will work will all
chart text boxes and data labels and user added textboxes.
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

diablo wrote:
"Don Guillett" wrote in message
...

You can use a shape from the drawing toolbarselect itin the formula box
type in =$d$18 if cell d18 contains the date

--
Don Guillett
SalesAid Software

"diablo" wrote in message
.. .


I tried what you suggest but I only see what I typed, =$g$1 which is the
cell that contains the date. I used a rectangle shape. I had tried this
already with a text box as well, it didn't work either.

Thanks,
Brian

try again.
place a text box anywhereclick on itgoto the formula boxtype in =d18 IN
THE FORMULA BOX enter


--
Don Guillett
SalesAid Software

"diablo" wrote in message
...
"Don Guillett" wrote in message
...
You can use a shape from the drawing toolbarselect itin the formula box
type in =$d$18 if cell d18 contains the date

--
Don Guillett
SalesAid Software

"diablo" wrote in message
...

I tried what you suggest but I only see what I typed, =$g$1 which is the
cell that contains the date. I used a rectangle shape. I had tried this
already with a text box as well, it didn't work either.

Thanks,
Brian

--

Hello, Kelly!
You wrote on Sat, 18 Nov 2006 11:49:47 -0500:

KO You can link cell contents to your chart. This link shows
KO you how to make a dynamic title that is linked to a cell.

KO KO Kelly

KO

KO "diablo" wrote in message
KO ...
?? Hello all,
??
?? Is there a way to link a chart to a cell on a spreadsheet
?? that contains the date? What I want to do is generate
?? weekly charts on production data, and pick up the date
?? that's put in a cell and display it either in the chart
?? title or near it. Can that be done?

To say it again, I live and learn!
http://processtrends.com/pg_chart_dy...hart_title.htm is
particularly useful since it shows a real example.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

"Don Guillett" wrote in message
...

try again.
place a text box anywhereclick on itgoto the formula boxtype in =d18 IN
THE FORMULA BOX enter


--
Don Guillett
SalesAid Software

"diablo" wrote in message
...


Don,

Thanks for being so insistent, ;-) I wasn't hitting "enter", it worked
great.

Thanks again,
Brian

Thanks for the link Kelly, I'll read up.

Brian

--

"Kelly O'Day" wrote in message
...
diablo:

You can link cell contents to your chart. This link shows you how to make
a dynamic title that is linked to a cell.

http://processtrends.com/pg_chart_dy...hart_title.htm

Kelly




"diablo" wrote in message
...
Hello all,

Is there a way to link a chart to a cell on a spreadsheet that contains
the date? What I want to do is generate weekly charts on production data,
and pick up the date that's put in a cell and display it either in the
chart title or near it.
Can that be done?

Thanks,
Brian

Very good site you have, thanks for the link, and your information.

Brian

--

"Andy Pope" wrote in message
...
Hi,

Explanation with respect to the chart title, but will work will all chart
text boxes and data labels and user added textboxes.
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

diablo wrote:
"Don Guillett" wrote in message
...

You can use a shape from the drawing toolbarselect itin the formula box
type in =$d$18 if cell d18 contains the date

--
Don Guillett
SalesAid Software

"diablo" wrote in message
. ..


I tried what you suggest but I only see what I typed, =$g$1 which is the
cell that contains the date. I used a rectangle shape. I had tried this
already with a text box as well, it didn't work either.

Thanks,
Brian

Very good site you have, thanks for the link, and your information.

Brian

--

"Andy Pope" wrote in message
...
Hi,

Explanation with respect to the chart title, but will work will all chart
text boxes and data labels and user added textboxes.
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

diablo wrote:
"Don Guillett" wrote in message
...

You can use a shape from the drawing toolbarselect itin the formula box
type in =$d$18 if cell d18 contains the date

--
Don Guillett
SalesAid Software

"diablo" wrote in message
. ..


I tried what you suggest but I only see what I typed, =$g$1 which is the
cell that contains the date. I used a rectangle shape. I had tried this
already with a text box as well, it didn't work either.

Thanks,
Brian

glad to help

--
Don Guillett
SalesAid Software

"diablo" wrote in message
...

"Don Guillett" wrote in message
...

try again.
place a text box anywhereclick on itgoto the formula boxtype in =d18
IN THE FORMULA BOX enter


--
Don Guillett
SalesAid Software

"diablo" wrote in message
...


Don,

Thanks for being so insistent, ;-) I wasn't hitting "enter", it worked
great.

Thanks again,
Brian