Combining 2 kinds of graphs [how?]

  • Thread starter Thread starter gordom
  • Start date Start date
G

gordom

Hi everyone.
I have a series of data (3 columns and several rows). Here you have the
example:


date & time |value1|value2|
2006-07-11 00:00:00 | -203 | |
2006-07-11 08:00:00 | -204 | |
2006-07-11 16:00:00 | -204 | |
2006-07-12 00:00:00 | -204 | |
2006-07-12 08:00:00 | -204 | |
2006-07-12 16:00:00 | -205 | |
2006-07-13 00:00:00 | -205 | |
2006-07-13 08:00:00 | -206 | |
2006-07-13 16:00:00 | -206 | |
2006-07-14 00:00:00 | -207 | |
2006-07-14 08:00:00 | -207 | -103 |
2006-07-14 16:00:00 | -219 | |
2006-07-15 00:00:00 | -209 | |
2006-07-15 08:00:00 | -208 | |
2006-07-15 16:00:00 | -208 | |
2006-07-16 00:00:00 | -209 | |
2006-07-16 08:00:00 | -209 | |
2006-07-16 16:00:00 | -209 | |
2006-07-17 00:00:00 | -209 | |
2006-07-17 08:00:00 | -210 | |
2006-07-17 16:00:00 | -210 | |
2006-07-18 00:00:00 | -210 | -198 |
2006-07-18 08:00:00 | -211 | |
2006-07-18 16:00:00 | -211 | |
2006-07-19 00:00:00 | -212 | |

Column A: shows date & time of the measurement
Column B: major value
Column C: additional value (measurement taken only from time to time)

All this data must be plotted in one diagram (Column A should be
presented on X-axis). Values in column B should be presented as a line
graph, values in column C as a column or scatter graph. I've tried to
solve that problem for several hours but with no success. Can anyone
help me please? Thanks in advance.

gordom
 
W dniu 2009-04-15 19:57, gordom pisze:
Hi everyone.
I have a series of data (3 columns and several rows). Here you have the
example:


date & time |value1|value2|
2006-07-11 00:00:00 | -203 | |
2006-07-11 08:00:00 | -204 | |
2006-07-11 16:00:00 | -204 | |
2006-07-12 00:00:00 | -204 | |
2006-07-12 08:00:00 | -204 | |
2006-07-12 16:00:00 | -205 | |
2006-07-13 00:00:00 | -205 | |
2006-07-13 08:00:00 | -206 | |
2006-07-13 16:00:00 | -206 | |
2006-07-14 00:00:00 | -207 | |
2006-07-14 08:00:00 | -207 | -103 |
2006-07-14 16:00:00 | -219 | |
2006-07-15 00:00:00 | -209 | |
2006-07-15 08:00:00 | -208 | |
2006-07-15 16:00:00 | -208 | |
2006-07-16 00:00:00 | -209 | |
2006-07-16 08:00:00 | -209 | |
2006-07-16 16:00:00 | -209 | |
2006-07-17 00:00:00 | -209 | |
2006-07-17 08:00:00 | -210 | |
2006-07-17 16:00:00 | -210 | |
2006-07-18 00:00:00 | -210 | -198 |
2006-07-18 08:00:00 | -211 | |
2006-07-18 16:00:00 | -211 | |
2006-07-19 00:00:00 | -212 | |

Column A: shows date & time of the measurement
Column B: major value
Column C: additional value (measurement taken only from time to time)

All this data must be plotted in one diagram (Column A should be
presented on X-axis). Values in column B should be presented as a line
graph, values in column C as a column or scatter graph. I've tried to
solve that problem for several hours but with no success. Can anyone
help me please? Thanks in advance.

gordom
Click to expand...

My problem regards Excel 2007
 
Initially use all the data to create a column graph. Then select only the
Series from column B, right-click, chart type, choose line.
 
Back
Top