I have created a line chart with one series which will be updated with each
month's information. Therefore, I currently have four month's worth of
information (Jan-Apr), the rest of the months are a plotted at zero. I am
trying to add another series to the chart to indicate the established
benchmark (23%) for twelve months . However, when I add the new series,
intead of the chart correctly indicating 23% for twelve months consecutive
months, it is taking the information from Jan-Apr and and then projecting the
line at 23% from that number (example: January's number is 10%, the new
series line is showing 23% at the 33% line.)

Hopefully I am clearer than mud...

Any and all responses GREATLY appreciated!

Hi,

Check the sub-type of the chart is not stacked line.
Right click chart and pick Chart Type.

Cheers
Andy

Brandy wrote:
I have created a line chart with one series which will be updated with each
month's information. Therefore, I currently have four month's worth of
information (Jan-Apr), the rest of the months are a plotted at zero. I am
trying to add another series to the chart to indicate the established
benchmark (23%) for twelve months . However, when I add the new series,
intead of the chart correctly indicating 23% for twelve months consecutive
months, it is taking the information from Jan-Apr and and then projecting the
line at 23% from that number (example: January's number is 10%, the new
series line is showing 23% at the 33% line.)

Hopefully I am clearer than mud...

Any and all responses GREATLY appreciated!


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks so much-I never thought to look at that!

"Andy Pope" wrote:

Hi,

Check the sub-type of the chart is not stacked line.
Right click chart and pick Chart Type.

Cheers
Andy

Brandy wrote:
I have created a line chart with one series which will be updated with each
month's information. Therefore, I currently have four month's worth of
information (Jan-Apr), the rest of the months are a plotted at zero. I am
trying to add another series to the chart to indicate the established
benchmark (23%) for twelve months . However, when I add the new series,
intead of the chart correctly indicating 23% for twelve months consecutive
months, it is taking the information from Jan-Apr and and then projecting the
line at 23% from that number (example: January's number is 10%, the new
series line is showing 23% at the 33% line.)

Hopefully I am clearer than mud...

Any and all responses GREATLY appreciated!


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info