Get two graphs on the same chart

**mufan** · 01-05-2011, 06:15 PM

Hi,
I have attached a spreadsheet where I am trying to graph two different y-axes over a period of time on the x-axis. However, I can't get the x axis (time) to cooperate. I have dates to the end of december 2010 but it won't graph the data out that far. Please help. Thanks.

**optkontek** · 01-05-2011, 06:45 PM

Hi. If you right-click a data point in your chart and select "Edit series" or to see what data you have plotted, you will notice that the AF column is only specified to row 14, when it should go to 16. You need to include the missing data to make it show up on the chart. The "unit 2" series seems fine. Hope this helps...

**mufan** · 01-05-2011, 07:20 PM

Actually, I only wanted it to row 14 but didn't specify that...sorry. The graph for unit 2 (series 2) is supposed to have data out to 12/13/10 but it only goes to 12/18/2009. I think it is because there are different dates for some of the points but I thought there would be a way to work it out?

**teylyn** · 01-05-2011, 10:11 PM

Hello,

change the chart type to XY Scatter chart and do not restrict the maximum date on the X axis.

Have you noticed that the dates are not in chronological order? E.g.
18/12/09
4/03/09
22/04/09
27/05/09
26/06/09

The chart makes much more sense with cell AJ7 being 18/12/08 instead.

cheers