Thanks.
But that does not work with varying time values that may include hours, minutes and seconds.
Using the hh:mm:ss format results in values that end with AM or PM.
Still need help.
Luke M, the examples in that webpage show how to work with dates set in a single column.
My dates span multiple columns i.e.:
Column Labels (5 Each)=
Location, 12/12/2011, 12/19/2011, 1/2/2012, 1/9/2012
Five columns of data (1st Column = ROW Labels):
1, 10, 11, 12...
I have to update a number of trend charts that span six week intervals.
Each chart is linked to six dated week columns for the X axis and one location column for the Y axis.
Every week the chart data is manually selected to reflect the most current six weeks.
I would like the most current six...
The explanation for using tables to make dynamic charts says adding rows will automatically update the chart.
I add columns each week.
Can the table method still be used?