Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Outlook Training and help » Outlook Advanced
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Outlook Advanced
Resolved · Low Priority · Version 2003
Reply
Outlook Advanced
In the calendar, when categorising appointments, is there a way of exporting information onto a pie chart which demonstrates how much time is spent in each category?For upcoming training course dates see: Pricing & availability
RE: Outlook Advanced
Hi Ellie,Thank you for your question. One way to achieve this may be to switch to your calendar view to events (View > Arrange by > Current view > Events).
This view includes the Duration and Categories fields. Select an event and use Ctrl+A and then Ctrl+c to select all and copy all the event information in your calendar.
Paste the contents into an excel spreadsheet and you can then use subtotals to add a subtotal for the total duration for each category.
Select the main two headings categories and duration, hold the CTRL key down and select the Subtotal headings and Subtotals and press F11 to chart.
I hope this helps - do let me know if you have any further questions.
Kind regards,
Simon
Mon 21 Sep 2009: Automatically marked as resolved.
|
 |
|
» Forum post: VBA |
Which vba internet forums can you recommend?
