Hello, I have an Excel combination chart already built and rockin'!!
My dilemma at the moment is in how to dynamically update the Excel charts (I have a different Excel chart for every County in their own respective tabs) based on the data in a different tab.
That tab being referenced is where I am storing all of the membership counts and calculated percentages of the membership counts for each category. For example, I have Fresno (region), Family (aid category), medi-cal (coverage type) listed as one of the rows where the column headings are all of the month by month percentages. These percentages are just calculations of the membership counts for each of the same categories (not sure all of that really matters for the question I am asking, but thought it might help).
So I did a little research and found 'Base the chart on an Excel table' at this link: http://office.microsoft.com/en-us/excel-help/update-the-data-in-an-existing-chart-HP010342980.aspx
but it doesn't work the way the short instructions say it will work??
If I click the chart and go to Select Data in Design tab, then click on the Chart Data Range button on right and then point to my tab that has all of the percentages and go to Insert tab, the Table button is grayed out (won't allow me to select it)??
I have tried to just highlight the whole cell range and insert Table by itself (not going through Select Data for the chart) and then add some new data for subsequent months, but that doesn't dynamically append new months to the chart either???
I hope I am explaining this dilemma well. Let me know if you understand what I am asking for and if so, please help me with this. Thank you.