Trendlines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access-to-Excel automation
to bring in 2 Columns of data...Week Ending Dates,
& a Value. These are the Source Data for a Vertical-Bar
Chart.

I have a 3rd column that uses this formula...
=IF(LEN(A8)=0,"",VLOOKUP(A8,TheLook,2))
to get Values for a Trendline...in "Column C".

I am NOT strong in Excel Charts at all, as I do
mostly Access Programming.

How can I take this "3rd-column" and assign that
to a Trendline?

TIA - Bob
 
Bob -

Excel can calculate a trendline from a charted series, but I sense this
isn't the trendline you mean. To add the data in column C as another
series in the chart, choose Source Data from the Chart menu, and click
on the Series tab. Click on the Add button, then click in the Values box
and select the range of data for the new series. Click in the Name box
and enter a name or click on a cell with the series name. If you are
using the same dates, you don't need to change the category labels.

You should change your formula to avoid false blanks (""). The NA()
function returns the #N/A error, which might look ugly in the sheet
(conditional formatting can hide it) but doesn't plot as a zero in most
chart types.

=IF(LEN(A8)=0,NA(),VLOOKUP(A8,TheLook,2))

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

If you mean the added series is plotted as a column chart series, right
click on the series, select Chart Type from the pop up menu, then select
the chart type that you wish to use.

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