Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to switch letters and numbers to other kinds? | Excel Discussion (Misc queries) | |||
Different kinds of data on chart | Charts and Charting in Excel | |||
Impossible to apply other kinds of character | Excel Discussion (Misc queries) | |||
Automatic Graphs/ Dynamic Graphs | Charts and Charting in Excel | |||
Line Graphs and Bar Graphs | Excel Discussion (Misc queries) |