Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combination charts
When I add a line graph to a bar chart, the bar width goes to zero and Excel
will not allow me to readjust the width. Is there a way to fix this? I'm using a secondary axis for the line graph. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Combination charts
Does the line chart use a time-scale axis? Are the points separated by a
number of days? Probably Excel is leaving room in between the existing bars for nonexistent bars on the in-between days. You can switch to a category type axis. Go to Chart menu Chart Options Axes, and select Category where Automatic is now selected. In Excel 2007, right click the axis, choose Format, and choose the Text option for axis type. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "DonnaK" wrote in message ... When I add a line graph to a bar chart, the bar width goes to zero and Excel will not allow me to readjust the width. Is there a way to fix this? I'm using a secondary axis for the line graph. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination charts | Charts and Charting in Excel | |||
Combination charts | Charts and Charting in Excel | |||
Combination Charts | Charts and Charting in Excel | |||
Combination bar Charts | Charts and Charting in Excel | |||
Combination Charts | Excel Discussion (Misc queries) |