If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2002 Chart
Hi. I inserted a scatter plot chart on a blank form, using
chart wizard. All the data points display just fine. However, I want a line to connect 2 data points on the same series. I changed the markers to have a line. However, since the 2 data points are not in a sequence, e.g. 1st data point = 6, 8 (where 6 is for x-axis, and 8 is for y-axis) and 2nd data point = blank, 3rd data point = 10,10. So, the chart won't show the line connect data point 1 and 3 without data for 2nd data point. Is there any suggestions? Thanks in advance! |
#2
|
|||
|
|||
Access 2002 Chart
1. Double-click on the Chart object to open Microsoft
Graph. 2. Use the MS Graph Menu Tools / Options ... / Chart tab and in the "Empty Cell plotted as " pane, select "Interpolated". 3. OK a few time to accept / save. HTH Van T. Dinh MVP (Access) -----Original Message----- Hi. I inserted a scatter plot chart on a blank form, using chart wizard. All the data points display just fine. However, I want a line to connect 2 data points on the same series. I changed the markers to have a line. However, since the 2 data points are not in a sequence, e.g. 1st data point = 6, 8 (where 6 is for x-axis, and 8 is for y-axis) and 2nd data point = blank, 3rd data point = 10,10. So, the chart won't show the line connect data point 1 and 3 without data for 2nd data point. Is there any suggestions? Thanks in advance! . |
Thread Tools | |
Display Modes | |
|
|