Export outlook calendar as graphic or gannt 1

[scottyjohn]

Hi all,
As per the title, Im looking for a way to print off an outlook calendar graphically to display a timeline if you like. Similar to the way the scheduling tab looks when you are scheduling a meeting. Is there any way, or using an additional tool to do this?

John

 

[SkipVought]

Hi,

You can EXPORT Outlook Calendar data as an Excel file, for instance.

The key fields you will need to plot a Bar Chart are ...
[tt]
Subject
StartDate
StartTime
EndDate
EndTime
[/tt]

Calculate 3 new columns
[tt]
End
Start
Dur
[/tt]
Assuming that your table starts in A1, the new columns will be in F, G & H
End is calculated as EndDate+EndTime, Start similarly and Dur (duration) is End-Start.

Select the Start & Dur headings and data.

Click the Chart Wizard.

Select STACKED BAR. FINISH. You can go back an pretty up as you wish.

Right-click the x-axis (vertical) and FORMAT.
Scale TAB - check Categories in reverse order

Select series "Start" (1).
Format Selected Data Series.
Paterns TAB - Border NONE - Area NONE

Right-Click tge y-axis (horizontal) and FORMAT.
Scale TAB -
Minimum: Enter the MINIMUM DATE like 12/04/2009
Maximum: Enter the MAXIMUM DATE & TIME like 12/04/2009 23:59:59
Number TAB -
Select the Date or Time format.

Right-Click in the chart and select Source Data
Series TAB -
Select the Start series.
Select in the Category (x) axis lables text box.
Select the Subject DATA on the sheet and OK

VOLA, y'all, Gantt you feel the excitement!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[scottyjohn]

Cheers that works a treat, but Im having a problem in that the calendar Im trying to export is not my own, but one I have permissions over. When I try to export the cal, it does not appear on the available list. I am working round it at the moment by creating a dummy calendar and then copying all the appointments from the calendar to that, as it does appear on the list of available export calendars. Not sure if this is a permission thing?

Any ideas?

John

 

[scottyjohn]

Anyone any help on why I cant export this additional calendar?

John