Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Axis Column Chart | Charts and Charting in Excel | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
combination x-y scatter and column graph | Charts and Charting in Excel | |||
Text Truncated on Vertical Chart Axis Label | Excel Discussion (Misc queries) | |||
Align Clustered Column Chart Category Axis Labels | Charts and Charting in Excel |