Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need x-Axis Pivot Chart Help
Hi.
I have a Pivot table with date in 1 column, time in another, and values in a 3rd. I want to set up a Pivot chart displaying the values as a function of both the date and time. Unfortunately, the chart displays all the times, but will only display the first date of the series. Can anyone tell me how to display all the dates as well as the times? Thanks. Thomas |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need x-Axis Pivot Chart Help
I should clarify that I am using Excel 2007. Thanks.
"tcdzomba" wrote: Hi. I have a Pivot table with date in 1 column, time in another, and values in a 3rd. I want to set up a Pivot chart displaying the values as a function of both the date and time. Unfortunately, the chart displays all the times, but will only display the first date of the series. Can anyone tell me how to display all the dates as well as the times? Thanks. Thomas |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need x-Axis Pivot Chart Help
Clarify with sample data.
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need x-Axis Pivot Chart Help
Here is an example:
date time value 09/22 0:00 4 09/22 1:00 3 .. .. .. 09/22 23:00 4 09/23 0:00 5 09/23 1:00 6 .. .. .. 09/30 23:00 4 The pivot chart would show the value as a function of both the date and the time. v a l u e 0:00 1:00 .......0:00.........0:00.......................... .23:00 09/22 09/23 09/24 ......................09/30 What's happening is that I only get 09/22 to show up for date, and nothing else. I never had this problem with excel 2003. Thanks for any help. Thomas "tcdzomba" wrote: Hi. I have a Pivot table with date in 1 column, time in another, and values in a 3rd. I want to set up a Pivot chart displaying the values as a function of both the date and time. Unfortunately, the chart displays all the times, but will only display the first date of the series. Can anyone tell me how to display all the dates as well as the times? Thanks. Thomas |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need x-Axis Pivot Chart Help
Excel 2007 PivotChart
This will happen for certain x-axis format combinations. Try: Axis Option Multi-level Category Labels checked Axis Option Specify interval units = 1 Alignment Text direction Rotate 90 (or 270) |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need x-Axis Pivot Chart Help
Herbert,
Tried that, but it did not make a difference. "Herbert Seidenberg" wrote: Excel 2007 PivotChart This will happen for certain x-axis format combinations. Try: Axis Option Multi-level Category Labels checked Axis Option Specify interval units = 1 Alignment Text direction Rotate 90 (or 270) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Axis Pivot Chart | Charts and Charting in Excel | |||
Pivot Chart Y Axis | Charts and Charting in Excel | |||
chart from pivot data does not update x-axis bar chart values - bug | Excel Discussion (Misc queries) | |||
How to sort x-axis in pivot chart | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel |