ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do you prepare monthly calendars in Excel from tabular data? (https://www.excelbanter.com/charts-charting-excel/132100-how-do-you-prepare-monthly-calendars-excel-tabular-data.html)

John H.

How do you prepare monthly calendars in Excel from tabular data?
 
I would like to prepare 30/31 day calendar graphics from Excel by importing
tabular event data into them. I know how to do this by exporting Excel data
to Outlook, but I'm not satisfied with the level of detail Outlook allows on
the 30/31 day calendar graphic. Any ideas how to do this completely within
Excel?

JH

ShaneDevenshire

How do you prepare monthly calendars in Excel from tabular data?
 
Hi John,

I don't know exactly what you want but Microsoft has 20-30 calendar
templates at Office Online which might get you started. In addition I have
created an Excel Calendar which I use for my day to day work, which I could
send you.

--
Cheers,
Shane Devenshire


"John H." wrote:

I would like to prepare 30/31 day calendar graphics from Excel by importing
tabular event data into them. I know how to do this by exporting Excel data
to Outlook, but I'm not satisfied with the level of detail Outlook allows on
the 30/31 day calendar graphic. Any ideas how to do this completely within
Excel?

JH


John H.

How do you prepare monthly calendars in Excel from tabular dat
 
Shane,

Do your templates allow the import of tabular Excel data into the 30/31 day
calendar format. The calendar format I'm referring to is the same as a
calendar you would hang on your wall (7 columns for each day of week and 5
rows).

JH


"ShaneDevenshire" wrote:

Hi John,

I don't know exactly what you want but Microsoft has 20-30 calendar
templates at Office Online which might get you started. In addition I have
created an Excel Calendar which I use for my day to day work, which I could
send you.

--
Cheers,
Shane Devenshire


"John H." wrote:

I would like to prepare 30/31 day calendar graphics from Excel by importing
tabular event data into them. I know how to do this by exporting Excel data
to Outlook, but I'm not satisfied with the level of detail Outlook allows on
the 30/31 day calendar graphic. Any ideas how to do this completely within
Excel?

JH


ShaneDevenshire

How do you prepare monthly calendars in Excel from tabular dat
 
No but you should check out the templates that I mentioned at Microsoft.
--
Thanks,
Shane Devenshire


"John H." wrote:

Shane,

Do your templates allow the import of tabular Excel data into the 30/31 day
calendar format. The calendar format I'm referring to is the same as a
calendar you would hang on your wall (7 columns for each day of week and 5
rows).

JH


"ShaneDevenshire" wrote:

Hi John,

I don't know exactly what you want but Microsoft has 20-30 calendar
templates at Office Online which might get you started. In addition I have
created an Excel Calendar which I use for my day to day work, which I could
send you.

--
Cheers,
Shane Devenshire


"John H." wrote:

I would like to prepare 30/31 day calendar graphics from Excel by importing
tabular event data into them. I know how to do this by exporting Excel data
to Outlook, but I'm not satisfied with the level of detail Outlook allows on
the 30/31 day calendar graphic. Any ideas how to do this completely within
Excel?

JH


Marco

How do you prepare monthly calendars in Excel from tabular dat
 
Hi. I have the same problem. I need to build a map that shows me the inicial
and the end of employes contracts.

Imagine that I have 10 employees. each one has a different star and end date
of their contract. each employees may have several contracts. I need to build
a map, if possible automtically that shows me all date from all contracts.

Regards,
marco




"ShaneDevenshire" wrote:

No but you should check out the templates that I mentioned at Microsoft.
--
Thanks,
Shane Devenshire


"John H." wrote:

Shane,

Do your templates allow the import of tabular Excel data into the 30/31 day
calendar format. The calendar format I'm referring to is the same as a
calendar you would hang on your wall (7 columns for each day of week and 5
rows).

JH


"ShaneDevenshire" wrote:

Hi John,

I don't know exactly what you want but Microsoft has 20-30 calendar
templates at Office Online which might get you started. In addition I have
created an Excel Calendar which I use for my day to day work, which I could
send you.

--
Cheers,
Shane Devenshire


"John H." wrote:

I would like to prepare 30/31 day calendar graphics from Excel by importing
tabular event data into them. I know how to do this by exporting Excel data
to Outlook, but I'm not satisfied with the level of detail Outlook allows on
the 30/31 day calendar graphic. Any ideas how to do this completely within
Excel?

JH



All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com