Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do 1 bar & 2 line series over the correct date?
I've selected my x-axis as the date (1/1/2007 to 12/31/07), which I chose
from a column in my excel spreadsheet. I have rainfall data plotted as a bar graph. I need to plot data from groundwater monitoring wells on the same graph as a line. This is easy enough for the wells that correctly collected data through the entire year, but I have 1 well that collected data from 1/1/07 to 2/24/07, went haywire for a while, then collected from 3/26/07 to 7/9/07 before it died. (in my other graphs, I have my well data displayed as a line plotted on a secondary Y-axis.) When I tried to plot the well data as 1 line, it didn't show the gap between 2/24 & 3/26. When I tried (several times) to plot 2 lines it starts both lines at the far left of the graph (i.e. 1/1/07). I need my second line to display correctly over the x-axis, beginning at 3/26. (I'm using MS Office 2007) Thanks for any help. (PS, I read some other postings & thought an XY graph might work, but when I tried that, I didn't see my data plotted anywhere). |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do 1 bar & 2 line series over the correct date?
Use one column of dates for all data. Put rainfall in the first data column
and the groundwater in the next. Leave a range of blank cells corresponding to dates where the data collection went awry. By default, Excel plots a gap for blank cells in a line chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Archambault" wrote in message ... I've selected my x-axis as the date (1/1/2007 to 12/31/07), which I chose from a column in my excel spreadsheet. I have rainfall data plotted as a bar graph. I need to plot data from groundwater monitoring wells on the same graph as a line. This is easy enough for the wells that correctly collected data through the entire year, but I have 1 well that collected data from 1/1/07 to 2/24/07, went haywire for a while, then collected from 3/26/07 to 7/9/07 before it died. (in my other graphs, I have my well data displayed as a line plotted on a secondary Y-axis.) When I tried to plot the well data as 1 line, it didn't show the gap between 2/24 & 3/26. When I tried (several times) to plot 2 lines it starts both lines at the far left of the graph (i.e. 1/1/07). I need my second line to display correctly over the x-axis, beginning at 3/26. (I'm using MS Office 2007) Thanks for any help. (PS, I read some other postings & thought an XY graph might work, but when I tried that, I didn't see my data plotted anywhere). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create vertical line to indicate date on chart with series of date | Charts and Charting in Excel | |||
Cutting a line in a line chart when data series stops | Charts and Charting in Excel | |||
Checking names on correct line across sheets | Excel Worksheet Functions | |||
how do I change a line series to a column series in excel? | Charts and Charting in Excel | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |