Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis in column chart
When I create a column chart, on the x-axis I have dates (30-Sep-04,
30-Sep-05 and 30-Sep-06) that repeat. (It's a double x axis where I have different office codes and the dates are shown for each office). When I first create it, the dates display nicely in a vertical orientation. However, when I add in the data table, it turns the dates all horizontal and cuts them off (all I see then is the 30-S). Any help on how to fix this? Thank you |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis in column chart
Data tables can mess up your chart. If there's little enough data to make a
data table legible, you have to ask yourself whether you even need a chart. And in any case, you need to ask whether the data table itself is really necessary, or could you use a standalone table in the cells near the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "aimee209" wrote in message ... When I create a column chart, on the x-axis I have dates (30-Sep-04, 30-Sep-05 and 30-Sep-06) that repeat. (It's a double x axis where I have different office codes and the dates are shown for each office). When I first create it, the dates display nicely in a vertical orientation. However, when I add in the data table, it turns the dates all horizontal and cuts them off (all I see then is the 30-S). Any help on how to fix this? Thank you |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis in column chart
The data table only has two rows. With values ranging from 0-1200, it's a
little difficult to see what the value are since that would mean putting in a lot of gridlines. The table allows you to see exactly what the values are for easy comparison. "Jon Peltier" wrote: Data tables can mess up your chart. If there's little enough data to make a data table legible, you have to ask yourself whether you even need a chart. And in any case, you need to ask whether the data table itself is really necessary, or could you use a standalone table in the cells near the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "aimee209" wrote in message ... When I create a column chart, on the x-axis I have dates (30-Sep-04, 30-Sep-05 and 30-Sep-06) that repeat. (It's a double x axis where I have different office codes and the dates are shown for each office). When I first create it, the dates display nicely in a vertical orientation. However, when I add in the data table, it turns the dates all horizontal and cuts them off (all I see then is the 30-S). Any help on how to fix this? Thank you |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
X axis in column chart
You've demonstrated how the data table clutters up the chart. You could
instead put data labels on the series (which adds its own clutter), or you could make an independent table which is not integral to the chart. Do you really gain any understanding in the reader by having the table integral with the chart, or does it just "look nicer" (except for the messed up labels)? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "aimee209" wrote in message ... The data table only has two rows. With values ranging from 0-1200, it's a little difficult to see what the value are since that would mean putting in a lot of gridlines. The table allows you to see exactly what the values are for easy comparison. "Jon Peltier" wrote: Data tables can mess up your chart. If there's little enough data to make a data table legible, you have to ask yourself whether you even need a chart. And in any case, you need to ask whether the data table itself is really necessary, or could you use a standalone table in the cells near the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "aimee209" wrote in message ... When I create a column chart, on the x-axis I have dates (30-Sep-04, 30-Sep-05 and 30-Sep-06) that repeat. (It's a double x axis where I have different office codes and the dates are shown for each office). When I first create it, the dates display nicely in a vertical orientation. However, when I add in the data table, it turns the dates all horizontal and cuts them off (all I see then is the 30-S). Any help on how to fix this? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get a column to appear along the horizontal axis of chart | New Users to Excel | |||
delete a # from the value axis on a column chart? | Excel Worksheet Functions | |||
Column chart with both value x and y-axis | Charts and Charting in Excel | |||
Problem with Column Chart on 2 Axis | Charts and Charting in Excel | |||
2 Axis Column Chart | Charts and Charting in Excel |