Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Display Issues with X-Axis
Hi All
i've some problems with a chart. To be precise, the chart works fine, the only thing that doesn't work the way I want it to is the X-Axis, or even more precisely the labels of the X-Axis. I have a 2-Axis Chart, with a line-chart linked to the primary Y-Axis and a bar-chart linked to the secondary Y-Axis. Now I wanted the X-Axis to display the Label. Not really a miracle that I'm expecting here, but Excel proves me wrong. Excel doesn't want to show me the labels, so i started to change things, like chart-size, fontsize and many other things, even Zoom. Well to be honest, if i would had to make subtle changes I and my boss wouldn't have any problems changing them. But the changes are all that big, that they are instantly recognizable if you look at the chart! Does anyone know of that problem? I could even send you the .xls!? Who knows, probably it works fine on your PC. Thanks to all Carlo |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Display Issues with X-Axis
Forgot to mention, that with the Major Changes the Labels are displayed!!
But I can't make those changes because it would look too bad! Thanks again Carlo |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Display Issues with X-Axis
Hi,
Some checks, that the category axis is linked to the correct cells. Right click chart and pick Source Data. On the series tab is a box for category labels range/text. right click the chart and pick chart options. On the axis tab make sure the X-axis is enabled. double click the x axis and on the patterns tab see if TickMarkLabels is set to None. Cheers Andy Carlo wrote: Hi All i've some problems with a chart. To be precise, the chart works fine, the only thing that doesn't work the way I want it to is the X-Axis, or even more precisely the labels of the X-Axis. I have a 2-Axis Chart, with a line-chart linked to the primary Y-Axis and a bar-chart linked to the secondary Y-Axis. Now I wanted the X-Axis to display the Label. Not really a miracle that I'm expecting here, but Excel proves me wrong. Excel doesn't want to show me the labels, so i started to change things, like chart-size, fontsize and many other things, even Zoom. Well to be honest, if i would had to make subtle changes I and my boss wouldn't have any problems changing them. But the changes are all that big, that they are instantly recognizable if you look at the chart! Does anyone know of that problem? I could even send you the .xls!? Who knows, probably it works fine on your PC. Thanks to all Carlo -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Display Issues with X-Axis
Hy Andy
thanks for your answer. unfortunately it didn't solve my problem. If I resize the chart area to, let's say 130%, then everything is displayed the correct way! And that's the big problem, i can't change the format of the chart (i.e. Size, Fontsize, Colors...) Would it help, if you would take a look at the File? Thanks again Carlo "Andy Pope" wrote: Hi, Some checks, that the category axis is linked to the correct cells. Right click chart and pick Source Data. On the series tab is a box for category labels range/text. right click the chart and pick chart options. On the axis tab make sure the X-axis is enabled. double click the x axis and on the patterns tab see if TickMarkLabels is set to None. Cheers Andy |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Display Issues with X-Axis
Email the file privately off newsgroup.
Carlo wrote: Hy Andy thanks for your answer. unfortunately it didn't solve my problem. If I resize the chart area to, let's say 130%, then everything is displayed the correct way! And that's the big problem, i can't change the format of the chart (i.e. Size, Fontsize, Colors...) Would it help, if you would take a look at the File? Thanks again Carlo "Andy Pope" wrote: Hi, Some checks, that the category axis is linked to the correct cells. Right click chart and pick Source Data. On the series tab is a box for category labels range/text. right click the chart and pick chart options. On the axis tab make sure the X-axis is enabled. double click the x axis and on the patterns tab see if TickMarkLabels is set to None. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Display Issues with X-Axis
The problem is caused by the first few cells of the category labels
range being empty. Putting spaces in the first cell will cause the other text to be displayed. The number of spaces required is dependent on the other text. Cheers Andy Carlo wrote: Hy Andy thanks for your answer. unfortunately it didn't solve my problem. If I resize the chart area to, let's say 130%, then everything is displayed the correct way! And that's the big problem, i can't change the format of the chart (i.e. Size, Fontsize, Colors...) Would it help, if you would take a look at the File? Thanks again Carlo "Andy Pope" wrote: Hi, Some checks, that the category axis is linked to the correct cells. Right click chart and pick Source Data. On the series tab is a box for category labels range/text. right click the chart and pick chart options. On the axis tab make sure the X-axis is enabled. double click the x axis and on the patterns tab see if TickMarkLabels is set to None. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Y Axis Label is Cutoff | Charts and Charting in Excel | |||
shift Y axis | Charts and Charting in Excel | |||
I want to display months and years on x axis | Charts and Charting in Excel | |||
how can I have a secondary axis bar not covering the primary axis | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel |