XL Guru and maxflia10, thanks to you both.
I know this is elementary Excel but I am yet to graduate from that Elementary school....lol
Well, I'm pretty sure you are both correct.
First of all, I just updated my Sheet1 to today's new data. Even before I even clicked on "Save" for that sheet I viewed the connected four charts and they were indeed updated without any further activity on my part.
Secondly, regarding the link you supplied XL Guru, you are also on the mark....IF I wanted to "Automatically Expand" my chart as future data was imported.
(Quoting from the link)...."How do you create a chart from a data range that will frequently change in size? Perhaps you collect weekly data, and would like the chart to automatically expand as each week's data is entered."
(also from the link)"I took the following sample data and created a column chart. Although there is no data for weeks 5 and 6, the labels are included in the chart's x-axis, because the chart's source data range is $A$1:$B$7.
In my case, when I created my data sheet I entered data (DATES) that went about a week beyond the day of creation. For example (and I hope I'm getting this right), in source data range $A$1 thru $B$12 I entered dates (labels) going out further than I had available data for ($B5 thru $B12). So that when I entered today's new data the charts showed the update including today's entry.
$A$1 thru $A12 have entries (DATES) but only $B1 thru $B4 are complete with $B5 thru $B12 waiting for future updates, and they are shown as "blank" on the charts. So, in effect, I have expanded the charts (yes?).
The labels are included in my chart's x-axis, because the chart's source data range is $A$1:$B$12.
Creating "Dynamic Names" (as the link instructs) I believe would allow the charts to automatically expand beyond my entries (x-axis).
I better stop at this point, I have a habit of over-explaining, and the more I preview this the more changes I make. But, I think you catch my drift....my charts were automatically updated and had I not put in source data beyond today's date and by creating Dynamic Names as the link instructs, the charts then would automatically expand as new data was entered.
Whew! thanks again....I believe I've learned much or I've perhaps become delusional. Certainly bordering on becoming incoherent.
ADD EDIT
After re-reading what XLGuru had in his reply it is actually stated quite clearly....
"Say you have data in A1:A4. If you build a chart based on that range & then add new data in A5:A10, it won't update.
You could base it on A1:A10 in the first place to cover, but initially only 4/10ths of the plot area would be filled, which looks odd."
Well, guess what? This is precisely what I did.
I was planning ahead. Knowing the length of time I would be entering data to the charts and wanting to see those future dates as "projections". Therefore, I suppose there can be two approaches: 1) build a chart with projections to be completed at a future date showing (as XL Guru puts it) only a percentage of the plot area to be filled or, 2) creating the Dynamic Names and let the chart automatically expand as new data is entered.
Nicely done!
Telstar :up:
