Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Column Chart Update automatically for all worksheets?
I have a workbook that contains 9 worksheets. The first worksheet contains
all of the sales data broken down by each of our warehouses. The other 8 worksheets shows a column chart for each of our 8 warehouses by month. When I enter the next month sales information into worksheet 1, I have to go through and update each worksheet following that one so it shows the next month in the chart. I would like to be able to update the first worksheet and all of the others follow automatically. Is this possible and do you have any suggestions that would help make this more automatic rather than so manual and time consuming? As and example, this is somewhat what the first worksheet looks like: 2/5/2007 3/5/2007 4/2/2007 5/4/2007 Status RSC 9 1 $10 $10 $7 $2 8 1 $5 $9 $6 $2 8 1 $3 $8 $5 $3 7 1 $2 $7 $4 $3 6 1 $1 $6 $4 $2 $1 $1 $1 $1 There will be 8 different sections just like this repeating down the spreadsheet and then the other tabs will be a column chart with each RSC on a different worksheet. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically update data across worksheets | Links and Linking in Excel | |||
how do I automatically update a text box in a chart? | Charts and Charting in Excel | |||
how do i get the data in a chart to automatically update? | Charts and Charting in Excel | |||
Update data automatically among worksheets | Excel Discussion (Misc queries) | |||
how do I update automatically other worksheets in a file | Excel Discussion (Misc queries) |