Question about a chart with two lines

[GIS2013]

Hi,
I've plotted a chart with two lines.
For one line I've data till December, and for the second only till October.
How can I present this chart while one line goes till Dec. and the other stops in Oct. Right now Excel is stopping both lines in Oct.
Thanks

[dogberry]

Hi

Have you tried adding the Dec data first view the chart then add the Oct its possible you have them the other way round. Charts are meant to be dynamic so it may not make any difference.

Chris

[Palmetto]

Just asking the obvious, but have you double-checked to see that your reference for the December data series actually includes all of the data cells up to that month?
Which series did you create first? If it was October, when you selected your cells for the X-axis (horizontal) labels, did you extend the reference to include through December? If not adjust, the reference to include all the cells.

[GIS2013]

Thank you both,
Chris - it works with an exception...
My data for line 1 have tiny terms (0.05, 0.03 etc.) while for line 2 they are in huge terms (7,000 etc).
So, as long as I put both lines on the same chart without any adjustment Chris' tip works and I notice x-axis stretces till Dec.
BUT - when I adjust one of the lines, by making two y-axis in order to make the chart reasonable, then x-axis shrinks back to Oct.
A mysterious?

[dogberry]

Hi


The one that is thousands see if reducing it to smaller numbers ie divide by 1000 and show in the legend that it reflects thousands and not just 7.


Chris

[GIS2013]

Doesn't work ...
BTW here are the datasets - zero's in A column represent Jan-11 and Feb-11, while zero's in B column (in the end) represent Nov-11 and Dec-11.
Trying to plot a chart in which axis-x starts in Jan-11 and ends in Dec-12, while when data are missing (the 4 zero's ...) the line is just starts only when there are data - i.e. in Mar-11 for A, and ends in Oct-12 for B...

A B
0 8,421
0 8,548
6.9% 9,265
6.6% 6,230
6.9% 8,026
6.0% 7,671
5.1% 8,041
4.2% 5,977
4.2% 5,469
4.8% 4,402
4.9% 6,980
5.1% 7,424
5.6% 7,429
5.8% 7,417
5.8% 7,644
5.3% 6,324
5.7% 9,420
5.5% 8,798
5.5% 10,187
5.8% 10,065
6.1% 6,676
5.9% 7,474
5.9% 0
5.2% 0

[dogberry]

Hi


Can you post a sample wroksheet


Chris

[GIS2013]

Hi, I'm very new here - how do I post a sample worksheet?

[dogberry]

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.



Chris

[GIS2013]

Hope you can see the file now

It really works

[dogberry]

Hi

Have a look is this close to what you are after.


Chris

[GIS2013]

Chris - many many thanks!

Axis-x is perfect now, it's something I didn't know how to do before..

If there is also a way to force the chart to ignore zero's and to stop/begin the line without taking into account zero's it would be great.

[dogberry]

Hi

Sorry missed December of the first one



Chris

[GIS2013]

got the new one. thanks

[dogberry]

Hi

Apart from the posts above you had your "small numbers" as numbers I changed that to percentage. Have a look through the file so you can see what changes I have made. If it is what you want dont forget to mark your thread as solved.


Chris

[GIS2013]

Yes, I've seen that. and it's very well. as I said, I'm rookie ... so where am I closing a thread?

[dogberry]

Hi

At the start of the thread you will see thread tools its in that pulldown.

Pleased to have helped


Chris