Line Chart issues

B

Brandy

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!
 
A

Andy Pope

Hi,

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

Cheers
Andy
 
B

Brandy

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

Andy Pope said:
Hi,

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

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top