Pivit Table Charts & Controls

  • Thread starter Thread starter DM
  • Start date Start date
D

DM

I am trying to find a way to automatically display the
current time and date on a chart created with a pivot
table. I have tried to insert controls, ie, a textbox but
get the error "unable to insert object"

Is there another way to do this?

Thanx

DM
 
The function you want is "=Now()" Place this in your
cell and then format cell to select the way you want the
date and/or time displayed.
 
Thank you for the tip and I understand the NOW
function... I am not trying to display the time and date
in my table or worksheet but I am trying to display the
current time and date on the charts themselves ....have
tried several methods but excel seems to not want to let
me place objects on a chart....was wondering if anyone had
another idea on how I can do this....
 
You can use a cell reference in the chart, but not a formula, so create
the date formula in a worksheet cell, then refer to that. For example,
in cell C6, enter your formula: =NOW()

Then, click on the chart to select it
Type an equal sign -- you'll see it appear in the formula bar
Click on the cell that contains the text for the chart, e.g. C6
Press the Enter key.
Move the textbox to any location in the chart area.
 
Back
Top