Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
A lot of times I plot hourly or even 15 minute data. Unless if I am doing a
simple line graph (which can be done with an XY plot) Excel will only plot the data as daily data. The only way to get around it is to change the X value data (date/time stamp) to regular text data. I want to be able to plot the flow on a line graph and the rain on the same graph (second y-axis) as a bar graph. Sample Data: A B C Date Time Flow(mgd) Rain(in) 2/13/2007 0:15 1.2 0 2/13/2007 0:30 1.3 0.1 2/13/2007 0:45 1.5 0.2 2/13/2007 1:00 1.1 0 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
show 3 sets of data per data point in a scatter plot | Charts and Charting in Excel | |||
How to convert half hourly data into hourly | Excel Discussion (Misc queries) | |||
How do I sample hourly data one time per day | New Users to Excel | |||
How do I plot two columns of data as one data point/marker in a ch | Charts and Charting in Excel | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel |