Ho do I make my data series touch the axis?

R

RSunday

I have made a combine chart showing bars and a trend line. I would lik ethe
trend line to touch the y-axis - and not just start at the middle of the
first bar.

How is that don?

And how do I specify the width of the bars? I want them to touch each other.

And how do I make my bars transparent? Somehow I cant activate the
transparency sliders on the fill effects menu.
 
J

Jon Peltier

In the trendline options, set the forecast to 0.5 units backwards and
forwards.

The columns will touch if you set the gap width to zero (double click the
series, go to the Options tab).

You can't get true transparency in an Excel chart until Excel 2007. The
sliders are a placebo to make you envy your Mac user friends. John
Walkenbach shows a trick for earlier versions of Excel here:

http://www.j-walk.com/ss/excel/usertips/tip071.htm

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sideways stacked bar charts with line series on the same axis 0
Chart data scrunches to left when adding X axis date series 0
multiple series bar and line chart 2
how do you change the way a series in plotted on a secondary axis 1
How do I make a chart with 4 bars on one axis/1 line on 2nd axis? 4
can't click on series, close to Y-Axis 1
Overlaying 2 Data Series with Different Time (X) Axis 3
How do I do different error bars within a series? 3

Top