Re: 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.





.

Relevant Pages

  • Re: Voters registration
    ... few voters with different last names living at the same address. ... labels for the same address. ... then a 5 digit zip? ... I also need to combine first names (ie Joe, Mary and John live ...
    (microsoft.public.access.queries)
  • Re: Voters registration
    ... Thanks Tom - let me clarify - there is only one table, ... Within the table there could be multiple people living at the ... labels for the same address. ... then a 5 digit zip? ...
    (microsoft.public.access.queries)
  • Re: Category axis label problem at column chart
    ... Andy Pope wrote: ... One space is not enough - only one digit is displayed. ... For me a single space just helps the chart wizard identify what it thinks are labels, ... It seems that the chart calculate required space for labels according to the first value in the label range. ...
    (microsoft.public.excel.charting)
  • Re: Problem with hostnames starting with hyphens, stars, etc. (but works fine on windows!)
    ... DNS domain names consist of "labels" separated by single dots. ... However, if a domain name is used to name a host, it ... Allowable characters in a label for a host name are only ASCII ... numbers, but may have a leading digit. ...
    (comp.os.linux.networking)
  • Re: Voters registration
    ... then a 5 digit zip? ... labels. ... I also need to combine first names (ie Joe, Mary and John live ... the same house - the address label should read - Joe, ...
    (microsoft.public.access.queries)