Display Date on Chart

  • Thread starter Thread starter diablo
  • Start date Start date
D

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
 
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
 
Don Guillett said:
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
Click to expand...
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 anywhere>click on it>goto the formula box>type in =d18 IN
THE FORMULA BOX >enter
 
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
 
Don Guillett said:
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]...
Click to expand...


Don,

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

Thanks again,
Brian
 
Back
Top