LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 47
Default Pivot Chart Axis Labels

When showing more than one field on the x-axis, how do I turn on/off axis
labels for only one field. For example I have a Pivot Chart with Year,
Month, Day, Hour on the x-axis. I want the field data to stay but I want to
turn off the labels the the "Hour" field because they are so close they just
look like a big thick black line on the x-axis. When I use Format Axis and
turn Tick Mark labels to None it turns them all off. I would like to show
the labels for Year, Month, Day but not Hour.
 
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
Axis Labels Cut off in Excel Chart EricT Charts and Charting in Excel 1 March 8th 07 11:58 AM
x-axis labels desappear if the chart is too big Luca Charts and Charting in Excel 2 February 8th 07 09:01 AM
Category Labels(X) axis on a chart: Ali Excel Worksheet Functions 2 January 19th 06 11:53 AM
how to put x axis values in the chart instead of x axis labels Sinclair Charts and Charting in Excel 1 June 21st 05 11:04 AM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 06:25 PM


All times are GMT +1. The time now is 06:11 AM.

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

About Us

"It's about Microsoft Excel"