ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Dotted lines for projections in graph (https://www.excelbanter.com/excel-worksheet-functions/189719-dotted-lines-projections-graph.html)

Brewhill

Dotted lines for projections in graph
 
I've created a line graph that compares number of sales from '06, '07
and '08. For sales from June '08 until the end of the year, I'd like
to show a dotted line in the graph but can't figure out how to show
this.

Can anyone help? Thanks!

Dave Curtis

Dotted lines for projections in graph
 
Hi,

Try adding a trendline, with a forecast of the appropriate amount, then
format it choosing the dotted line option.

Dave

url:http://www.ureader.com/msg/104234537.aspx


All times are GMT +1. The time now is 03:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com