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.
 

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

Similar Threads

Pls help for Simple Calculation 1
Formatting time 2
Formating time 2
Combined Statements 1
Conditional Formatting 1
Date Calculation Problem 4
Time Duration Calculation help needed 4
Sumproduct 1

Back
Top