Updating a Date in a Graph Header Field

  • Thread starter Thread starter geniusbiz
  • Start date Start date
G

geniusbiz

I would like to have the header on a graph update the date when I
update the spreadsheet. For example, The header reads: "Payments by
Category - August 31, 2006" but the next month when I update the data,
I want it to read: "Payments by Category - September 30, 2006". Can
anyone help me with this?

Thanks in advance.
 
Hi

Rather than using the chart header, insert a text box with a reference to a
cell, and have the cell work out what date you want to show

eg

Text Box 1 - formula = '=$D$1'

D1 - formula = '="Payments by Category - "&TEXT(EOMONTH(TODAY(),0),"mmmm dd,
yyyy")'

Best rgds
Chris Lav
 
You must log in or register to reply here.

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

Similar Threads

Sorting amounts in columns by due dates 7
Use if functions with dates 1
Allocate an income payment over a date range (tax years) 7
Graphs not updating 2
Calculating Previous Pay Dates 8
How do I create a graph from a worksheet? 2
Calculate a date based on period and year 5
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0

Back
Top