Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Line Drawing Between Separated Data Points ?
Hello:
Have a chart made from a table that has bolood pressure readings as a function of dates. Some dates are skipped. The chart generated now connects a line between all the dates points that are there, sequentially, irrespective of whether there are points for all the (daily) dates. Is it possible for the generated chart to have the line missing for dates for which there is no data, and then to resume connecting the dots between actual data ponts ? Graph looks funny for data points connected for each day, which is what I want of course, and then a line connecting two points perhaps a week apart (for when on vacation with no data). Thanks, Bob |
#2
|
|||
|
|||
goto
<tools<options<chart and select "not plotted for active chart "Robert11" wrote: Hello: Have a chart made from a table that has bolood pressure readings as a function of dates. Some dates are skipped. The chart generated now connects a line between all the dates points that are there, sequentially, irrespective of whether there are points for all the (daily) dates. Is it possible for the generated chart to have the line missing for dates for which there is no data, and then to resume connecting the dots between actual data ponts ? Graph looks funny for data points connected for each day, which is what I want of course, and then a line connecting two points perhaps a week apart (for when on vacation with no data). Thanks, Bob |
#3
|
|||
|
|||
Hi,
In order to break the line for dates you have not recorded you will have provide at least 1 extra data point. Here is a data set for the 1st 10 days in January. Where no reading was taken for the 4th to the 6th. Your chart will still connect the 3rd to the 7th. 01-Jan-05 1 02-Jan-05 1 03-Jan-05 1 07-Jan-05 1 08-Jan-05 1 09-Jan-05 1 10-Jan-05 1 So to break the line you need to add a empty date. 01-Jan-05 1 02-Jan-05 1 03-Jan-05 1 03-Jan-05 07-Jan-05 1 08-Jan-05 1 09-Jan-05 1 10-Jan-05 1 This will cause the line to break if your chart option is set to 'Not plotted (leave gaps)'. To check and set this select the chart and use the menu Tools Options Chart. Cheers Andy Robert11 wrote: Hello: Have a chart made from a table that has bolood pressure readings as a function of dates. Some dates are skipped. The chart generated now connects a line between all the dates points that are there, sequentially, irrespective of whether there are points for all the (daily) dates. Is it possible for the generated chart to have the line missing for dates for which there is no data, and then to resume connecting the dots between actual data ponts ? Graph looks funny for data points connected for each day, which is what I want of course, and then a line connecting two points perhaps a week apart (for when on vacation with no data). Thanks, Bob -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
interpolate missing data between points | Excel Worksheet Functions | |||
Display negative data points differently. | Charts and Charting in Excel | |||
How many data points can you have in an Excel for a Scatter Chart. | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel |