Line Graph Issue

**keli** · 07-07-2009, 11:47 AM

Hi, I have an issue I am trying to represent data in line graph, several columns are included. The columns are labelled with:

Carbon Dioxide emissions, relative humidity, temperature, dewpoint, number of students and their Percentages obtain in that order. I have made the number of students the primary axis and the others secondary. Carbon dioxide on the left and the relative humidity, temperature and percentages on the right.

The results stop at less say if there are 50 persons with 50 different percentages, however I need to see the 250 data of CO2, RH and DP values in the graph which comes from an equipment as well.

If this is posssible, how can I represent the graph so that all the values from the other 4 columns are included?

Thank you for your help!

**Andy Pope** · 07-07-2009, 11:48 AM

Can you post example workbook, it may help us understnad your problem

**keli** · 07-07-2009, 11:52 AM

I have attached a excel data listing with graph

**Andy Pope** · 07-07-2009, 12:04 PM

I don't think you can mix the series on axis as you are trying to do.

I'm going off line now but will check again in the morning.

**Andy Pope** · 07-08-2009, 05:23 AM

You can not mix the varying length data series across the axes.

A line chart has a categorical X axis. So either 1 to 28 for the number of students. Or 1 to 245 for the number of points in the first for series.

If you do mix series on axis then the students information will appear in the first 28 slots.

The only way I can see you combining the information is to some how convert the 245 values for the series except CO2 to 28 values.