Excel Graph Data

[Win2Win]

When you select a region of data for a graph;
='Main Page'!$D$1044:$D$1080
It shows the graph. Nice!! :geek

However, I add one line on per day. Is their a command that replaces $D$1080, and instead says 'until the end of data'?

Quicker asking on here than going through the Excel handbook.

Ta.

[mathare]

I've not used charting much but you can extend the upper range of the chart beyond your current data (say to D1200) but Excel will probably show the right hand end of the graph as blank beyond your current data extent so your data won't fill the chart.

Personally I quite like this approach as you can then see the data growing to fill the chart and you are not then looking at a chart of one scale on one day and a different scale the next - it is always the same scale.

Or you could write a bit of VBA to set the chart up using commands like IF(ISEMPTY...)) to find the end of your data and pass that into the charting commands

[TheOldhamWhisper]

If using Excel 2003:

...To designate a data area as a list, click in a cell in the soon-to-be list, and choose Data | List | Create List. Then create your chart using the list data. Now, whenever you add new data to your list, the data area plotted by the chart expands automatically to include it.

[Win2Win]

I'll give Oldham's idea ago.

Problem with me is, I've spent over the last year just doing Excel with VBA, mostly with Betangel, so now I refer back to just basic Excel with no VBA, I've forgotten some of it!!! :laugh

[mathare]

I tend to try and VBA my way out of a problem when faced with one. I'll maybe try the Excel help and have a bit of a play but in the end I'll probably just code a macro to do it for me.

I know some folk don't like their workbooks to contain macros though.

[Win2Win]

Done it :D Although they've renamed 'List' as 'Table' in Excel 2007 :splapme

I'm just lazy, but it saves editing all the graphs every few days.