Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Neil
 
Posts: n/a
Default Calendar based on varying information/ Pivot Table General

Is there a way to create a calendar in any office suite program of say 150
events with start and end dates. Can the calendar control be used to display
certain events when a user such as my boss pivots the data to show only
certain events in specific states?

My second question is can pivot tables display actual text, as opposed to
only numbers and summary info in the data field? IE- im trying to make a
text pivot table for these events, by pivoting dates, companies, states...

Any suggestion would be greatly appreciated!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing errors from a Pivot table Mighty Magpie Excel Discussion (Misc queries) 2 February 3rd 05 04:15 PM
Pivot Table Security in Excel JBankson Excel Discussion (Misc queries) 0 February 2nd 05 01:01 AM
How to create a calculated field formula based on Pivot Table resu dha17 Excel Discussion (Misc queries) 1 December 15th 04 06:39 AM
Pivot table help:calculated field based on previous consecutive va martin Excel Discussion (Misc queries) 0 December 9th 04 09:33 PM
Problem with Pivot Table Drop-Down Menus Mac Excel Worksheet Functions 4 November 7th 04 02:18 PM


All times are GMT +1. The time now is 03:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"