| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining 2 kinds of graphs [how?]
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining 2 kinds of graphs [how?]
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 My problem regards Excel 2007 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining 2 kinds of graphs [how?]
Initially use all the data to create a column graph. Then select only the
Series from column B, right-click, chart type, choose line. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "gordom" wrote: 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 My problem regards Excel 2007 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
![gordom[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
