Fabulous Dotted Line In Excel Chart

The time scale is 2000 to 2007 and Id like the forecast data ie.

Dotted line in excel chart. Add dotted forecast line in an Excel line chart To add a dotted forecast line in an existing line chart in Excel please do as follows. If you click on one of the dots a second time then you can edit one smaller segment of the line at a time. This step-by-step guide will show you how to add target values to your excel charts.

In this article you will learn how to remove dashed print area lines in Excel. W hen plotting Actuals and Forecasts on a single line chart you may want to use a vertical dotted line to identify where the Actuals finish and the Forecasts begin. Im using Office Excel.

Under the Page Setup group click on the Print Area button. A vertical line appears in your Excel bar chart and you just need to add a few finishing touches to make it look right. Attached is an excel file to accompany the guide you will see the various steps outlined in the excel chart Adding_horizontal_linexlsx.

Due to Page breaks where Excel visually show page breaks as dotted lines Borders that have been set to show as dotted lines Gridlines that appear in the whole worksheet. Kutools for Excel - Includes more than 300 handy tools for. To achieve this effect add a line to your chart as explained in the previous examples and then do the following customizations.

This chart shows actuals so far in a solid line with forecast numbers in a dashed line. Seems easy enough but often the result is less than ideal. Therefore the line should be solid to 2004 then dotted thereafter.

The dot controls the piece of the line just before it. Right-click on that dot and select Outline. When individual points re formatted differently and there is only one series in the chart Excel helpfully.