Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 17th 08, 05:00 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
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.

  #2   Report Post  
Old December 22nd 08, 07:38 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2008
Posts: 1
Default Pivot Chart Axis Labels

Did you eventually discover a solution?
  #3   Report Post  
Old December 23rd 08, 06:58 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3,346
Default Pivot Chart Axis Labels

Hi,

What exactly do you want to know about Pivot Chart Axis Labels?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"unknown" wrote:


  #4   Report Post  
Old December 23rd 08, 06:59 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2008
Posts: 3,346
Default Pivot Chart Axis Labels

Sorry to reply twice to this, but I forgot to mention that you should always
include a question in the body of your email, not simply in the title.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"unknown" wrote:




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
Axis Labels Cut off in Excel Chart EricT Charts and Charting in Excel 1 March 8th 07 12:58 PM
x-axis labels desappear if the chart is too big Luca Charts and Charting in Excel 2 February 8th 07 10:01 AM
Category Labels(X) axis on a chart: Ali Excel Worksheet Functions 2 January 19th 06 12:53 PM
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 07:25 PM


All times are GMT +1. The time now is 02:59 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017