Excel Chart with 2 bars and 2 trend lines

G

Guest

I want to produce a single Excel chart with 2 bars per period and two trend
lines running above the bars. The bars show current and prior year debtor
balances per month for a 12 month period. The trend lines shown current and
prior year DSO figures.
 
J

Jon Peltier

Simon -

Are these trendlines, which show a statistical fit of the series they
represent? Or are they additional series, plotted with lines instead of
more columns?

If these are trendlines, plot your columns, then select one series, and
use Add Trendline from the Chart menu. Repeat for the other series.

If these are additional series, start by charting all four as columns,
then select each one you want to change, and use Chart Type on the Chart
menu to change it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

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

Top