Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Continuous series plot
I am trying to plot concentration vs. time. My conc. values are hourly recorded values i.e. 24 readings in a day. I want the plot to show, Y - axis as concentration X - axis as dates, i.e. 8/1 8/2 8/3 8/4 etc. In between 8/1 and 8/2 all the 24 points should be plotted, same for 8/2 and 8/3,and so on. So it should be a continuous plot of data points. but as i mentioned xaxis should show only the dates and not each hour. can someone tell me how to do this labeling or is there some way to plot it. thank you all for the help. demi. -- dharmik ------------------------------------------------------------------------ dharmik's Profile: http://www.excelforum.com/member.php...o&userid=25463 View this thread: http://www.excelforum.com/showthread...hreadid=472674 |
#2
|
|||
|
|||
Excel stores dates as whole numbers and times as fractions (of a day). Put your
date-time values together in one column, in a convenient format, like October 3, 2005 2:00 pm When you make your chart, use this date-time range as your X values, and make an XY chart, NOT a line chart. The XY chart treats the date-time as continuously variable, while the line chart only recognizes the integer part, or the day but not the time. Finally, when formatting the chart's axis, enter dates as the min and max, and use a major unit of 1 (or another whole number). - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ dharmik wrote: I am trying to plot concentration vs. time. My conc. values are hourly recorded values i.e. 24 readings in a day. I want the plot to show, Y - axis as concentration X - axis as dates, i.e. 8/1 8/2 8/3 8/4 etc. In between 8/1 and 8/2 all the 24 points should be plotted, same for 8/2 and 8/3,and so on. So it should be a continuous plot of data points. but as i mentioned xaxis should show only the dates and not each hour. can someone tell me how to do this labeling or is there some way to plot it. thank you all for the help. demi. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
In excel scatter plot with 2 series, how do I connect xy coordinat | Charts and Charting in Excel | |||
Plot points with same x-value in same series? | Charts and Charting in Excel | |||
How can I plot a data series from multiple worksheets | Charts and Charting in Excel | |||
How can I plot a data series from multiple worksheets | Charts and Charting in Excel |