Help With Ms Excel Graphs 19.06.08
I have 2 excel spreadsheet reports that contain bar chart graphs that get updated on a weekly basis.
The first spreadsheet report (which is an overview of 3 regions) has a bar chart graph where the data series are broken down by weeks and regions.
The second spreadsheet report contains 3 bar chart graphs (one for each region) with their data series also broken down by weeks and regions.
The data is updated every week, so each week new data rows are added however I’m wanting the graphs to update automatically as currently the graph data series must be manually selected, which is time consuming. There is also a trend line on the graphs that get updated with most current weeks figures.
I also want the ability to scroll the graphs left and right as they will build up over time and will start to get cluttered.
Please see the project message board for a sample of the 2 spreadsheets referred to above.
