Excel Chart Help: Actual to Forecast line graph

[DaveF602]

Hi All,

I am creating a line chart template in excel 2010 and need some help. I would like to visually merge the actual data (solid line) and the Forecasted data (dash line) so that it looks like one seamless line on the chart. The data set that I am pulling from is a set of formulas 5 plots of data calendarized. Any suggestions on how to acomplish this would be great, I am sure it is a common problem but I havent been able to find any online help.

 

[Ben Nevis]

if you create a line chart using the following data; Col A being the X Axis Labels and Cols B and C being Series 1 and 2 respectively, the chart will look as though it is a continuous line but you can format the 2 parts separately as you require

<style type="text/css">
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style><table class="tableizer-table">
<tr class="tableizer-firstrow"><th>1</th><th>1</th><th> </th></tr>
<tr><td>2</td><td>1.1</td><td> </td></tr>
<tr><td>3</td><td>1.2</td><td> </td></tr>
<tr><td>4</td><td>1.3</td><td> </td></tr>
<tr><td>5</td><td>1.4</td><td> </td></tr>
<tr><td>6</td><td>1.5</td><td>1.5</td></tr>
<tr><td>7</td><td> </td><td>1.6</td></tr>
<tr><td>8</td><td> </td><td>1.7</td></tr>
<tr><td>9</td><td> </td><td>1.8</td></tr>
<tr><td>10</td><td> </td><td>1.9</td></tr>
</table>

 

[DaveF602]

Thanks for the reply...my problem is the data table is a set of formulas and I can't populate both columns with the same number. I could manually over-write the formula but I am trying to use this as a mater template that will be used by an entire department.