|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
| Notices |
 |
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
09-04-2008, 09:37 AM
|
|||
|
|||
|
Comparing complete with incomplete years data
I have created a table and a graph that shows the activity for 4 consultants over a period of time (06/07, 07/08 and YTD for 08/09)
I feel that the graph isn’t a true reflection of the activity, because the first two financial years (06/07 and 07/08) are full complete years running from April to Mar. But for the last financial year 08/09, the data only runs from April through to August. So the graph I have drawn doesn’t show this! What would be the best way to graphically show this? I want to make clear that I am comparing complete with incomplete years data. Thanks in advance Last edited by akhlaq768; 09-04-2008 at 10:07 AM. 
|
|
#2
09-04-2008, 09:52 AM
|
||||
|
||||
|
Please take the time to read the forum rules... and then change your title accordingly....
__________________
Where there is a will there are many ways. Finding one that works for you is the challenge! Please read the Forum Rules: Rules
|
|
#3
09-04-2008, 09:53 AM
|
||||
|
||||
|
In your excel sheet is just the final pivot table data, so we cannot see the underlying data.
1) you could interpolate the missing data to make it a full 12 month period. 2) Show YTD for the other years as well 3) Use percentages instead of absolutes
|
|
#4
09-04-2008, 10:14 AM
|
|||
|
|||
|
Thanks for the quick reply,
The underlying data is hidden, to unhide it, go to 'Format' > 'Sheets' > 'Unhide' you mentioned that i can interpolate the missing data? for the rest of the months, how do i do this? Showing the YTD for the rest of the years, is a good idea. i'll give that a try.
|
|
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Bar - Line Graph Combo | AccountantCost | Excel Charting | 2 | 08-18-2008 11:25 PM |
| Can I 'auto-graph' or 'graph on the fly?' | AdamB5000 | Excel General | 2 | 07-09-2008 12:19 PM |
| Stacking a bar graph?? | mike_hill2107 | Excel Charting | 3 | 06-26-2008 05:34 AM |
| Questionnaire - Graph creation | akhlaq768 | Excel General | 0 | 02-12-2008 06:54 PM |
| Updating graph range in macro | y2gordo | Excel Programming | 2 | 03-21-2007 03:02 AM |
Linear Mode
