Display Date on Chart

[diablo]

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]

You can use a shape from the drawing toolbar>select it>in the formula box
type in =$d$18 if cell d18 contains the date

 

[diablo]

You can use a shape from the drawing toolbar>select it>in the formula box
type in =$d$18 if cell d18 contains the date

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

--

 

[Kelly O'Day]

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_dynamic_chart_title.htm

Kelly

(e-mail address removed)

 

[Andy Pope]

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

 

[Don Guillett]

try again.
place a text box anywhere>click on it>goto the formula box>type in =d18 IN
THE FORMULA BOX >enter

 

[James Silverton]

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> (e-mail address removed)

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

 

[diablo]

try again.
place a text box anywhere>click on it>goto the formula box>type in =d18 IN
THE FORMULA BOX >enter


--
Don Guillett
SalesAid Software
(e-mail address removed)
news:[email protected]...

Don,

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

Thanks again,
Brian

 

[diablo]

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

Brian

--

 

[diablo]

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

Brian

--

 

[diablo]

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

Brian

--

 

[Don Guillett]

glad to help