How do I add a trendline to a chart? Valerian 20.07.2006 17:42:01 I need to add a basic trendline to a chart. I know I have seen it before but I can't find it now that I need it. Go figure...

Re: How do I add a trendline to a chart? "Rick Brandt" <rickbrandt2[ at ]hotmail.com> 20.07.2006 18:32:12 Valerian wrote: [Quoted Text] > I need to add a basic trendline to a chart. I know I have seen it > before but I can't find it now that I need it. Go figure... Double click the chart to bring up the chart designer interface. Then single click on the series in the chart that you want to add a trendline for. Once selected then right-click and choose "Add trendline" from the menu. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com

Re: How do I add a trendline to a chart? Valerian 20.07.2006 18:40:02 Rick, Thanks but that option is greyed out. Any idea why? "Rick Brandt" wrote: [Quoted Text] > Valerian wrote: > > I need to add a basic trendline to a chart. I know I have seen it > > before but I can't find it now that I need it. Go figure... > > Double click the chart to bring up the chart designer interface. Then > single click on the series in the chart that you want to add a trendline > for. Once selected then right-click and choose "Add trendline" from the > menu. > > -- > Rick Brandt, Microsoft Access MVP > Email (as appropriate) to... > RBrandt at Hunter dot com > > > >

Re: How do I add a trendline to a chart? "Rick Brandt" <rickbrandt2[ at ]hotmail.com> 20.07.2006 19:09:17 Valerian wrote: [Quoted Text] > Rick, > Thanks but that option is greyed out. Any idea why? What is the chart type? Some types don't support trendlines. Column graphs and line graphs definitely should and area graphs definitely do not. I'd have to look at any others. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com

Re: How do I add a trendline to a chart? Valerian 20.07.2006 20:12:01 It is a line gragh. I am stumped??? "Rick Brandt" wrote: [Quoted Text] > Valerian wrote: > > Rick, > > Thanks but that option is greyed out. Any idea why? > > What is the chart type? Some types don't support trendlines. Column graphs > and line graphs definitely should and area graphs definitely do not. I'd > have to look at any others. > > -- > Rick Brandt, Microsoft Access MVP > Email (as appropriate) to... > RBrandt at Hunter dot com > > >

Re: How do I add a trendline to a chart? "Rick Brandt" <rickbrandt2[ at ]hotmail.com> 20.07.2006 22:50:06 Valerian wrote: [Quoted Text] > It is a line gragh. I am stumped??? Are you quite sure you have the chart series selected? -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com

Re: How do I add a trendline to a chart? Valerian 20.07.2006 23:12:01 yes, I think it must have something to do with the way I created the chart. Maybe I should start over? Thank you for all your time today. "Rick Brandt" wrote: [Quoted Text] > Valerian wrote: > > It is a line gragh. I am stumped??? > > Are you quite sure you have the chart series selected? > > -- > Rick Brandt, Microsoft Access MVP > Email (as appropriate) to... > RBrandt at Hunter dot com > > >