G
Guest
Is there a way to close the gap in a mixed bar/line chart so the line extends closer to the edge of the chart?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jon Peltier
You could double click the line, and on the Axis tab select Secondary.
This gives you a secondary Y axis. Right click on the chart, choose
Chart Options, and on the Axes tab, check the secondary category axis
box. Double click the new X axis, and on the Scale tab, uncheck the
Crosses Between Categories box.
The problem with this is that it decouples the categories of the two
series, so the line points are all shifted slightly toward the closer
side of the chart.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
This gives you a secondary Y axis. Right click on the chart, choose
Chart Options, and on the Axes tab, check the secondary category axis
box. Double click the new X axis, and on the Scale tab, uncheck the
Crosses Between Categories box.
The problem with this is that it decouples the categories of the two
series, so the line points are all shifted slightly toward the closer
side of the chart.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
T
Tushar Mehta
No, not without some fudging. Any solution (like the one Jon proposed)
*has* to shift the line categories so that they no longer synchronize
with the bar categories.
If the data for the line are such that you can create a trendline
(select the series then Chart | Add Trendline...) that goes precisely
through each point, you could then extend that trendline 0.5 unit
forward and 0.5 unit backward (double-click the trendline, then select
the Options tab).
If not, here's the last fallback possibility: Convert the line to a XY
Scatter chart (hopefully, that is acceptable). Now, add the first two
points as a separate standalone series. Create a linear trendline for
this dummy series and extend it backwards by 0.5 units. Create another
dummy series but this time you will also have to specify x values. The
x values should be n-1 and n where n are the number of points in the
original series. The y values for this, the 2nd dummy series, will be
the last two values of the original line chart. For this new dummy
series, create a linear trendline and extend it forward by 0.5 units.
Format everything for aesthetic appeal.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
*has* to shift the line categories so that they no longer synchronize
with the bar categories.
If the data for the line are such that you can create a trendline
(select the series then Chart | Add Trendline...) that goes precisely
through each point, you could then extend that trendline 0.5 unit
forward and 0.5 unit backward (double-click the trendline, then select
the Options tab).
If not, here's the last fallback possibility: Convert the line to a XY
Scatter chart (hopefully, that is acceptable). Now, add the first two
points as a separate standalone series. Create a linear trendline for
this dummy series and extend it backwards by 0.5 units. Create another
dummy series but this time you will also have to specify x values. The
x values should be n-1 and n where n are the number of points in the
original series. The y values for this, the 2nd dummy series, will be
the last two values of the original line chart. For this new dummy
series, create a linear trendline and extend it forward by 0.5 units.
Format everything for aesthetic appeal.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions