Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Marko Pinteric
 
Posts: n/a
Default Category axis label problem at column chart


Dear experts!

I have a column chart. Category axis labels are either time ("hh:mm")
or empty ("") cells. If first value in the label range is time,
e.g. ("13:00"; ""; "14:00"; ""), everything is fine, in the opposite
case, e.g. (""; "13:00"; ""; "14:00"), labels are not displayed. It
seems that the chart calculate required space for labels according to
the first value in the label range.

Is there any way to solve this problem, so labels will be displayed
regardless of the fact if first value in label range is empty or not?

Thanks, Marko.
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Category axis label problem at column chart

Hi,

Easiest thing is to include a space in the first cell.
(" "; "13:00"; ""; "14:00")

Cheers
Andy

Marko Pinteric wrote:

Dear experts!

I have a column chart. Category axis labels are either time ("hh:mm")
or empty ("") cells. If first value in the label range is time,
e.g. ("13:00"; ""; "14:00"; ""), everything is fine, in the opposite
case, e.g. (""; "13:00"; ""; "14:00"), labels are not displayed. It
seems that the chart calculate required space for labels according to
the first value in the label range.

Is there any way to solve this problem, so labels will be displayed
regardless of the fact if first value in label range is empty or not?

Thanks, Marko.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Posted to microsoft.public.excel.charting
Marko Pinteric
 
Posts: n/a
Default Category axis label problem at column chart


I was testing that. More spaces, more numbers are displayed. For the
whole time number ("hh:mm") it requires about nine spaces. Problem is
that depending on other graph specifics it requres less or more spaces
(from 8 to 10). Is there any more stable solution?

Marko.

Andy Pope wrote:
Hi,

Easiest thing is to include a space in the first cell.
(" "; "13:00"; ""; "14:00")

Cheers
Andy

Marko Pinteric wrote:


Dear experts!

I have a column chart. Category axis labels are either time ("hh:mm")
or empty ("") cells. If first value in the label range is time,
e.g. ("13:00"; ""; "14:00"; ""), everything is fine, in the opposite
case, e.g. (""; "13:00"; ""; "14:00"), labels are not displayed. It
seems that the chart calculate required space for labels according to
the first value in the label range.

Is there any way to solve this problem, so labels will be displayed
regardless of the fact if first value in label range is empty or not?

Thanks, Marko.



  #4   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Category axis label problem at column chart

I'm not sure I follow.

For me a single space just helps the chart wizard identify what it
thinks are labels, series data and series names. Adding more spaces has
no other effect.

How many category labels do you have?

Cheers
Andy

Marko Pinteric wrote:

I was testing that. More spaces, more numbers are displayed. For the
whole time number ("hh:mm") it requires about nine spaces. Problem is
that depending on other graph specifics it requres less or more spaces
(from 8 to 10). Is there any more stable solution?

Marko.

Andy Pope wrote:

Hi,

Easiest thing is to include a space in the first cell.
(" "; "13:00"; ""; "14:00")

Cheers
Andy

Marko Pinteric wrote:


Dear experts!

I have a column chart. Category axis labels are either time
("hh:mm") or empty ("") cells. If first value in the label range is
time,
e.g. ("13:00"; ""; "14:00"; ""), everything is fine, in the opposite
case, e.g. (""; "13:00"; ""; "14:00"), labels are not displayed. It
seems that the chart calculate required space for labels according to
the first value in the label range.

Is there any way to solve this problem, so labels will be displayed
regardless of the fact if first value in label range is empty or not?

Thanks, Marko.





--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #5   Report Post  
Posted to microsoft.public.excel.charting
Marko Pinteric
 
Posts: n/a
Default Category axis label problem at column chart



I was trying that already. More spaces, more of the digits of the time
are displayed. It takes around nine spaces to display the whole time.
The number of spaces depends on chart's properties.

Isn't there a more stable and elegant solution?

Marko.

Andy Pope wrote:
Hi,

Easiest thing is to include a space in the first cell.
(" "; "13:00"; ""; "14:00")

Cheers
Andy

Marko Pinteric wrote:


Dear experts!

I have a column chart. Category axis labels are either time ("hh:mm")
or empty ("") cells. If first value in the label range is time,
e.g. ("13:00"; ""; "14:00"; ""), everything is fine, in the opposite
case, e.g. (""; "13:00"; ""; "14:00"), labels are not displayed. It
seems that the chart calculate required space for labels according to
the first value in the label range.

Is there any way to solve this problem, so labels will be displayed
regardless of the fact if first value in label range is empty or not?

Thanks, Marko.





  #6   Report Post  
Posted to microsoft.public.excel.charting
Marko Pinteric
 
Posts: n/a
Default Category axis label problem at column chart


About 100 labels (every second time labels (hh.mm), other are emtpy labels).

One space is not enough - only one digit is displayed (first digit of
hour). More spaces - more digits.

Marko

Andy Pope wrote:
I'm not sure I follow.

For me a single space just helps the chart wizard identify what it
thinks are labels, series data and series names. Adding more spaces has
no other effect.

How many category labels do you have?

Cheers
Andy

Marko Pinteric wrote:


I was testing that. More spaces, more numbers are displayed. For the
whole time number ("hh:mm") it requires about nine spaces. Problem is
that depending on other graph specifics it requres less or more spaces
(from 8 to 10). Is there any more stable solution?

Marko.

Andy Pope wrote:

Hi,

Easiest thing is to include a space in the first cell.
(" "; "13:00"; ""; "14:00")

Cheers
Andy

Marko Pinteric wrote:


Dear experts!

I have a column chart. Category axis labels are either time
("hh:mm") or empty ("") cells. If first value in the label range is
time,
e.g. ("13:00"; ""; "14:00"; ""), everything is fine, in the opposite
case, e.g. (""; "13:00"; ""; "14:00"), labels are not displayed. It
seems that the chart calculate required space for labels according
to the first value in the label range.

Is there any way to solve this problem, so labels will be displayed
regardless of the fact if first value in label range is empty or not?

Thanks, Marko.





  #7   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Category axis label problem at column chart

Double click the axis and on the scale tab check the 'Number of
Categories between tick marks' value is 1.

Cheers
Andy

Marko Pinteric wrote:

About 100 labels (every second time labels (hh.mm), other are emtpy
labels).

One space is not enough - only one digit is displayed (first digit of
hour). More spaces - more digits.

Marko

Andy Pope wrote:

I'm not sure I follow.

For me a single space just helps the chart wizard identify what it
thinks are labels, series data and series names. Adding more spaces
has no other effect.

How many category labels do you have?

Cheers
Andy

Marko Pinteric wrote:


I was testing that. More spaces, more numbers are displayed. For
the whole time number ("hh:mm") it requires about nine spaces.
Problem is that depending on other graph specifics it requres less or
more spaces (from 8 to 10). Is there any more stable solution?

Marko.

Andy Pope wrote:

Hi,

Easiest thing is to include a space in the first cell.
(" "; "13:00"; ""; "14:00")

Cheers
Andy

Marko Pinteric wrote:


Dear experts!

I have a column chart. Category axis labels are either time
("hh:mm") or empty ("") cells. If first value in the label range
is time,
e.g. ("13:00"; ""; "14:00"; ""), everything is fine, in the opposite
case, e.g. (""; "13:00"; ""; "14:00"), labels are not displayed.
It seems that the chart calculate required space for labels
according to the first value in the label range.

Is there any way to solve this problem, so labels will be displayed
regardless of the fact if first value in label range is empty or not?

Thanks, Marko.







--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #8   Report Post  
Posted to microsoft.public.excel.charting
Marko Pinteric
 
Posts: n/a
Default Category axis label problem at column chart


I have that...

Marko

Andy Pope wrote:
Double click the axis and on the scale tab check the 'Number of
Categories between tick marks' value is 1.

Cheers
Andy

Marko Pinteric wrote:


About 100 labels (every second time labels (hh.mm), other are emtpy
labels).

One space is not enough - only one digit is displayed (first digit of
hour). More spaces - more digits.

Marko

Andy Pope wrote:

I'm not sure I follow.

For me a single space just helps the chart wizard identify what it
thinks are labels, series data and series names. Adding more spaces
has no other effect.

How many category labels do you have?

Cheers
Andy

Marko Pinteric wrote:


I was testing that. More spaces, more numbers are displayed. For
the whole time number ("hh:mm") it requires about nine spaces.
Problem is that depending on other graph specifics it requres less
or more spaces (from 8 to 10). Is there any more stable solution?

Marko.

Andy Pope wrote:

Hi,

Easiest thing is to include a space in the first cell.
(" "; "13:00"; ""; "14:00")

Cheers
Andy

Marko Pinteric wrote:


Dear experts!

I have a column chart. Category axis labels are either time
("hh:mm") or empty ("") cells. If first value in the label range
is time,
e.g. ("13:00"; ""; "14:00"; ""), everything is fine, in the opposite
case, e.g. (""; "13:00"; ""; "14:00"), labels are not displayed.
It seems that the chart calculate required space for labels
according to the first value in the label range.

Is there any way to solve this problem, so labels will be
displayed regardless of the fact if first value in label range is
empty or not?

Thanks, Marko.








  #9   Report Post  
Posted to microsoft.public.excel.charting
Marko Pinteric
 
Posts: n/a
Default Category axis label problem at column chart


F column looks like:

12:30, 13:00, 13:30, 14:00, 14:30, ..

G column has formula:

=IF(MINUTE(F1)=0;F1;"")

so G column looks like

"", 13:00, "", 14:00, "", ...

G column is also range for category labels.

In the example above, nothing is displayed on category axis.


If I change formula to

=IF(MINUTE(F1)=0;F1;" ")

only first digit is displayed

" ", "1", " ", "2", " ", ...


Marko.


Andy Pope wrote:
Double click the axis and on the scale tab check the 'Number of
Categories between tick marks' value is 1.

Cheers
Andy

Marko Pinteric wrote:


About 100 labels (every second time labels (hh.mm), other are emtpy
labels).

One space is not enough - only one digit is displayed (first digit of
hour). More spaces - more digits.

Marko

Andy Pope wrote:

I'm not sure I follow.

For me a single space just helps the chart wizard identify what it
thinks are labels, series data and series names. Adding more spaces
has no other effect.

How many category labels do you have?

Cheers
Andy

Marko Pinteric wrote:


I was testing that. More spaces, more numbers are displayed. For
the whole time number ("hh:mm") it requires about nine spaces.
Problem is that depending on other graph specifics it requres less
or more spaces (from 8 to 10). Is there any more stable solution?

Marko.

Andy Pope wrote:

Hi,

Easiest thing is to include a space in the first cell.
(" "; "13:00"; ""; "14:00")

Cheers
Andy

Marko Pinteric wrote:


Dear experts!

I have a column chart. Category axis labels are either time
("hh:mm") or empty ("") cells. If first value in the label range
is time,
e.g. ("13:00"; ""; "14:00"; ""), everything is fine, in the opposite
case, e.g. (""; "13:00"; ""; "14:00"), labels are not displayed.
It seems that the chart calculate required space for labels
according to the first value in the label range.

Is there any way to solve this problem, so labels will be
displayed regardless of the fact if first value in label range is
empty or not?

Thanks, Marko.








  #10   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Category axis label problem at column chart

Then I'm not sure what is causing the problem.
If you want you can email me (off newsgroup) with the file and I will
have a look see.

Marko Pinteric wrote:

I have that...

Marko

Andy Pope wrote:

Double click the axis and on the scale tab check the 'Number of
Categories between tick marks' value is 1.

Cheers
Andy

Marko Pinteric wrote:


About 100 labels (every second time labels (hh.mm), other are emtpy
labels).

One space is not enough - only one digit is displayed (first digit of
hour). More spaces - more digits.

Marko

Andy Pope wrote:

I'm not sure I follow.

For me a single space just helps the chart wizard identify what it
thinks are labels, series data and series names. Adding more spaces
has no other effect.

How many category labels do you have?

Cheers
Andy

Marko Pinteric wrote:


I was testing that. More spaces, more numbers are displayed. For
the whole time number ("hh:mm") it requires about nine spaces.
Problem is that depending on other graph specifics it requres less
or more spaces (from 8 to 10). Is there any more stable solution?

Marko.

Andy Pope wrote:

Hi,

Easiest thing is to include a space in the first cell.
(" "; "13:00"; ""; "14:00")

Cheers
Andy

Marko Pinteric wrote:


Dear experts!

I have a column chart. Category axis labels are either time
("hh:mm") or empty ("") cells. If first value in the label range
is time,
e.g. ("13:00"; ""; "14:00"; ""), everything is fine, in the opposite
case, e.g. (""; "13:00"; ""; "14:00"), labels are not displayed.
It seems that the chart calculate required space for labels
according to the first value in the label range.

Is there any way to solve this problem, so labels will be
displayed regardless of the fact if first value in label range is
empty or not?

Thanks, Marko.










--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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
2 Axis Column Chart dguilbault Charts and Charting in Excel 4 April 5th 06 12:23 PM
Positioning Numeric Values Resulting from 6 Column Array Formula Sam via OfficeKB.com Excel Worksheet Functions 2 January 5th 06 03:03 AM
combination x-y scatter and column graph David Charts and Charting in Excel 5 December 11th 05 07:49 PM
Text Truncated on Vertical Chart Axis Label Adrian Excel Discussion (Misc queries) 1 October 20th 05 11:50 AM
Align Clustered Column Chart Category Axis Labels Stephanie Charts and Charting in Excel 1 April 7th 05 03:21 PM


All times are GMT +1. The time now is 06:01 PM.

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

About Us

"It's about Microsoft Excel"