Hello again - always more questions with me, and never any answers......
I'm using Excel 2007 and trying to build a pie chart for the distribution of accounts by branch (8 branches) for the current month. I have the month-end dates in Column A, my branches in columns (B thru I), then my data in each row. I would like to build the pie chart only one time, so that as I enter the data in subsequent rows as time inevitably marches on, that the chart will show the "most current month end data".
I looked at some of the dynamic charting sites, and found very valuable information for charting info over multiple time frames (2 or more), but didn't find anything that would work for only one time frame.
Thanks again for any and all assistance!
I'm using Excel 2007 and trying to build a pie chart for the distribution of accounts by branch (8 branches) for the current month. I have the month-end dates in Column A, my branches in columns (B thru I), then my data in each row. I would like to build the pie chart only one time, so that as I enter the data in subsequent rows as time inevitably marches on, that the chart will show the "most current month end data".
I looked at some of the dynamic charting sites, and found very valuable information for charting info over multiple time frames (2 or more), but didn't find anything that would work for only one time frame.
Thanks again for any and all assistance!
