Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Missing Axis Category Labels
Excel 2003 worksheet opened in Exceel 2007. Data is 15 (0, 15,30, 45) minute
readings by hr. by date. When making chart from pivot table, area chart shows date, hour, and minute labels for day 1 only, day 2 - end of chart only show munute labels. Missing are Category labels for date and hour. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Missing Axis Category Labels
Thought an example might help.
Chart data is from Pivot Table Day Hour Min Total 2/1/2007 0 0 12.6 15 12.9 30 12.9 45 12.9 1 0 12.9 15 13.1 30 12.2 45 12.8 2 0 13.5 ...continues 23 0 13.1 15 12.9 30 12.7 45 12.1 2/2/2007 0 0 12.1 15 12.9 30 13.0 ....repeats like this to end of month. Excel 2003 chart labels look something like this; (|=tick mark grid lines) ----------------- --------------------------------- ------------------------------ |0134|0134|01 34|0134|0134|0134|0134|0 0134|0134|0134|0134|01 |0 |1 |23 |0 |1 |2 |3 23 |0 |1 |2 |3 | 2/1/2007 | 2/2/2007 | 2/28/2007 Excel 2007 chart labels look something like this; (only displays day 1 labels) ----------------- --------------------------------- ------------------------------ |0134|0134|01 34|0134|0134|0134|0134|0 0134|0134|0134|0134|01 |0 |1 |2 |23 | | | | | | | | | 2/1/2007 | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing text in category axis label | Charts and Charting in Excel | |||
Category Labels(X) axis on a chart: | Excel Worksheet Functions | |||
alignment of y axis category labels | Charts and Charting in Excel | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel |