I have an excel pivot table with a connection to an access database that tracks my employees vacation dates. I am trying to set up the pivot table so it will show me the begining and end dates of the vacation attached to each employee in a chart. I have been able to get the pivot chart to have the correct fields in the axis', but whenever I drag the begin or end dates to the pivot table, it automatically counts the records instead of looking at the date itself. Does anyone know how I could get it to stop counting the records and pull the dates themselves into the chart?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Trouble with counts in pivot tables/charts
- Thread starter HawkGuru
- Start date
-
- Tags
- count pivot chart pivot table
Similar threads
- Question
- Solved
