Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 9th 08, 01:48 PM posted to microsoft.public.excel.charting
Leo Leo is offline
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2008
Posts: 3
Default Hiding categories in the category axis of a chart

Dear all;

Maybe some of you can help me with this problem:

I have a chart in which the category axis is "months" from October
2003 to November 2007. The years are not important, but I would like
to put the different months as one-letter labels: O N D J F ... A
further restriction is that I only want a few labels, to avoid making
the chart axis too cluttered, so say I want O J O (for October
(2003), January (2004), October (2005), etc.). This can be easily done
with; that is, leaving the unwanted fields empty.

Col A Col B
O 65.418
64.633
65.602
J 67.508
67.337
....

However, and here comes the tricky part, I would like to have all the
data as well: O N D J... In other words, the question is: without
using text boxes, is there a way to "choose" which categories will
make it to the category axis, while still keeping all of them
associated to the chart source data? I have MS Excel 2003.

Any ideas would be appreciated. Thanks very much for your time.

Leo

  #2   Report Post  
Old February 9th 08, 02:19 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 560
Default Hiding categories in the category axis of a chart

On Sat, 9 Feb 2008, in microsoft.public.excel.charting,
Leo said:
I only want a few labels, to avoid making the chart axis too cluttered,
so say I want O J O (for October (2003), January (2004), October
(2005), etc.).


Did you try:

Format Axis.. Scale.. Number of categories between tick mark labels..?

What about it do you find unsatisfactory?

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.
  #3   Report Post  
Old February 9th 08, 04:28 PM posted to microsoft.public.excel.charting
Leo Leo is offline
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2008
Posts: 3
Default Hiding categories in the category axis of a chart

Del;

Thank you very much, that worked like a charm. And sorry for the noob
question.

Thanks,

Leo

On Feb 9, 8:19 am, Del Cotter wrote:
On Sat, 9 Feb 2008, in microsoft.public.excel.charting,
Leo said:

I only want a few labels, to avoid making the chart axis too cluttered,
so say I want O J O (for October (2003), January (2004), October
(2005), etc.).


Did you try:

Format Axis.. Scale.. Number of categories between tick mark labels..?

What about it do you find unsatisfactory?

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.




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
Column Chart - X axis too thin because of MANY categories. Mike Charts and Charting in Excel 3 June 15th 06 01:18 PM
stock chart category axis Bill Charts and Charting in Excel 2 March 13th 06 02:28 PM
Sub-Categories for X-axis labels, line on bar chart? cfagan Charts and Charting in Excel 1 March 3rd 06 06:01 PM
How do I make the Y axis in an excel chart the category axis? megnadoodle Charts and Charting in Excel 2 March 29th 05 09:27 AM
Bar chart & Category (x) axis labels Airi A. Charts and Charting in Excel 0 March 15th 05 04:09 PM


All times are GMT +1. The time now is 12:55 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017