singleton2787
asked on
Graph based on Date Range
I would like to be able to:
* Redraw graph based on date range
* Show PIE chart based on date range to show were time is being allocated
Additonally, is there way to format this data so as the weeks are appended on (up to a 52 weeks), the spreadsheet doesn't get cumbersome?
Workload-WIP.xlsx
* Redraw graph based on date range
* Show PIE chart based on date range to show were time is being allocated
Additonally, is there way to format this data so as the weeks are appended on (up to a 52 weeks), the spreadsheet doesn't get cumbersome?
Workload-WIP.xlsx
ASKER
I was going to point the source to the data in the same workbook I posted, apologies
Hello,
I see no way the chart and the data on the Data Entry sheet have anything in common. Where is the "Actual" data in the table? There are no dates in the source data. The way your data is laid out in the Data Entry sheet does not lend itself to charting easily.
Can you explain in words what you want to chart?
I see no way the chart and the data on the Data Entry sheet have anything in common. Where is the "Actual" data in the table? There are no dates in the source data. The way your data is laid out in the Data Entry sheet does not lend itself to charting easily.
Can you explain in words what you want to chart?
ASKER
Here is a newer version of the spreadsheet. The data and the graph are linked now.
ASKER
file...oops
Workload-WIP.xlsx
Workload-WIP.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Spectacular! Thanks!
ASKER
Sorry, one last question... How do I make a single source of data entry? The columnar (Columns A,B,C on 'Data and pivot table report' tab appear to be where the Pivot grpahs are pulled from?
I would like the columns F-N be the data source for all, they would be easier to enter data on.
I would like the columns F-N be the data source for all, they would be easier to enter data on.
Hello,
to change the source of a Pivot table, select the pivot table and on the Options Tab of the PivotTable Tools click Change Data Source. You will then get a dialog where you can select the range for the pivot table.
cheers, teylyn
to change the source of a Pivot table, select the pivot table and on the Options Tab of the PivotTable Tools click Change Data Source. You will then get a dialog where you can select the range for the pivot table.
cheers, teylyn
the chart in the attached file links to an external source. No way of doing anything with the chart unless you post the source data.
cheers, teylyn