![]() |
| 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
|
|||
|
|||
|
Hi, I have chart with a line graph and want to add individual points to the
chart that do not fall on the line. I do not want the points to be connected to the line and want them to show up as individual entities. I tried making separate series with one point but that did not work. Is there any way to do this? Thanks |
| Ads |
|
#2
|
|||
|
|||
|
Stewart1234 -
Use an XY (Scatter) chart type. Make the extra points a separate data series. If you have already done this, then explain what you mean by "that did not work" - Mike http://www.mikemiddleton.com "Stewart1234" > wrote in message ... > Hi, I have chart with a line graph and want to add individual points to > the > chart that do not fall on the line. I do not want the points to be > connected > to the line and want them to show up as individual entities. I tried > making > separate series with one point but that did not work. Is there any way to > do > this? > > Thanks |
|
#3
|
|||
|
|||
|
Thanks, that worked. I did not realize that you could connect points in a
series on a scatter graph. "Mike Middleton" wrote: > Stewart1234 - > > Use an XY (Scatter) chart type. > > Make the extra points a separate data series. > > If you have already done this, then explain what you mean by "that did not > work" > > - Mike > http://www.mikemiddleton.com > > "Stewart1234" > wrote in message > ... > > Hi, I have chart with a line graph and want to add individual points to > > the > > chart that do not fall on the line. I do not want the points to be > > connected > > to the line and want them to show up as individual entities. I tried > > making > > separate series with one point but that did not work. Is there any way to > > do > > this? > > > > Thanks > > > |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Adding Horizontal line to a graph | WhytheQ | Excel Discussion (Misc queries) | 1 | June 15th 06 02:42 AM |
| How do i get lines on a line graph? | baffledbrewer | Charts and Charting in Excel | 2 | June 4th 06 01:38 PM |
| How do i get lines on a line graph? | baffledbrewer | Charts and Charting in Excel | 2 | June 4th 06 01:31 PM |
| Automatically adding Vertical lines after certain points in line graph | matthoffman33 | Charts and Charting in Excel | 4 | March 7th 06 01:50 AM |
| create space in line chart between points, linked to pivot table | Mike -Z- | Charts and Charting in Excel | 1 | December 7th 04 09:39 PM |