View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Display Date on Chart

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