Excel Chart with 2 bars and 2 trend lines

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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/
_______
 
Back
Top