Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how do i update a chart area automatically
Hello,
I have an offset formula I use to update a chart plotted by columns. I name the ranges and change the range areas to the offset formula...something like this =Offset(Sheet1! $A$2,0,0,CountA(Sheet1! $A:A)-1). Basically, makes all the rows available for charting minus the row with the label. I use this same technique for two columns...Column A acts as the Category x axis and Column B as the value axis. Works beautifully Now, I would like to come up with a way to plot by rows. My values would grow as new field names would be added across the columns...specifically, Jan, Feb, March and then have April, May and June added to the plot area automatically. C138:C147 would have the names of sales reps and D137:F137 would hold the Month labels and then D138: F147 would list the values. So the list of sales reps is static, but new data comes in for each month and needs to be added to the charts. I have many of these charts on a dash board and do not want to update all of them every month. Any suggestions would be appreciated alathough I want to use VBA as a last resort. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart values do not update links to new worksheet | Charts and Charting in Excel | |||
Area chart with smoothed line | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Area Chart Formatting Question | Charts and Charting in Excel |