automatic date in chart


C

casey

In January, Jon Peltier replied to a question of inserting a date in a chart
that would dynamically change.

"select the title, type = in the formula bar, then click on the
cell. This works with chart titles, axis titles, data labels, and shapes
(text boxes etc)."

It worked perfectly for me, however, there seems to be a continuous
iteration of the formula. When I click on any of the charts I have added
this to, the calculation seems to begin and it (along with the hourglass)
continuously blinks. I click off the chart and it ceases. Any ideas why?

Thanks,
casey
 
Ad

Advertisements

C

casey

For all who will come up with an answer to this, I may have solved my
problem. There are several thousand links to another excel database. If
that is not opened while I'm making changes then apparently this phenomena
occurs. By keeping the "linked" excel open it does not occur.

tia anyway,
casey
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top