Ideally without having to go into the chart each month and modify the data source's?
A data source might look like this:
X 32 153 439 43 201 119 74
Y 350 841 987 437.5 493 293 387
Z 507 320 782 463 629 676 475
Combined 857 1161 1769 900.5 1122 969 862
Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06
But each month another column is added. Can the end of the data source be so automated? I don't want a chart with blank entries for the not-yet-filled-in months.
<Thinks...> In fact, I need the addition of the new months data to sheet to be automated as well! Well, why not?
Thanks.
Bookmarks