Combining 2 kinds of graphs [how?]

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
 
G

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
 
L

Luke M

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

Return column values based on criteria (HLOOKUP & VLOOKUP?) 0
Pls help for Simple Calculation 1
Daily cumulative timesheet entries 0
Formatting time 2
Conditional Formatting 0
Formating time 2
Calculating occupational sick pay entitlement 0
Time Duration Calculation help needed 4

Top