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
|
|||
|
|||
Scatter Chart Data Point Highlighting
I have a scatter chart with smooted lines and no data markers that represents a (one) mathematical function. Is it possible to highlight (mark) one data point and from that point draw parallel (dashed) lines to the x and y axes? By hovering over the chart you can pop up the data values but I want (if possible) the parrallel lines to better visualize the position of the selected point on the axes. -- rvExcelNewTip ------------------------------------------------------------------------ rvExcelNewTip's Profile: http://www.excelforum.com/member.php...o&userid=15668 View this thread: http://www.excelforum.com/showthread...hreadid=498625 |
#2
|
|||
|
|||
Scatter Chart Data Point Highlighting
Hi,
Add an extra series to the chart. This only needs a single x and y value. Change the series to plot a data marker with no line. Use the X and Y error bars of the new series to make connecting lines from the point to the axes. Cheers Andy rvExcelNewTip wrote: I have a scatter chart with smooted lines and no data markers that represents a (one) mathematical function. Is it possible to highlight (mark) one data point and from that point draw parallel (dashed) lines to the x and y axes? By hovering over the chart you can pop up the data values but I want (if possible) the parrallel lines to better visualize the position of the selected point on the axes. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Scatter Chart Data Point Highlighting
See Ed Ferrero's Intercept Vertical Lines example.
http://www.edferrero.com/Charting.aspx Andy Pope wrote: Hi, Add an extra series to the chart. This only needs a single x and y value. Change the series to plot a data marker with no line. Use the X and Y error bars of the new series to make connecting lines from the point to the axes. Cheers Andy rvExcelNewTip wrote: I have a scatter chart with smooted lines and no data markers that represents a (one) mathematical function. Is it possible to highlight (mark) one data point and from that point draw parallel (dashed) lines to the x and y axes? By hovering over the chart you can pop up the data values but I want (if possible) the parrallel lines to better visualize the position of the selected point on the axes. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
|
|||
|
|||
Scatter Chart Data Point Highlighting
I tried the error bar approach because it looked the simplest and most straightforward . But I'm now stuck with the following snag: The Y-axis has a logarithmic scale and whatever I try, I cannot get an error bar DOWN from the data point to the X-axis! I specified a value of 100% for the error, or alternatively I tried to Customize with the Negative Y-value (workshell location of Y value) but to no avail. If I selected Both (to have the error bar extended on both sides of the data point) only the upper part showed up! I'm working with Excel 2003. Is this a bug or does it "works as designed"? -- rvExcelNewTip ------------------------------------------------------------------------ rvExcelNewTip's Profile: http://www.excelforum.com/member.php...o&userid=15668 View this thread: http://www.excelforum.com/showthread...hreadid=498625 |
#6
|
|||
|
|||
Scatter Chart Data Point Highlighting
Hi,
Try adding another single point that is the correct X value, Y value is the same as where the x-axis crosses the Y axes. And use the + custom error bar value linked to the Y value. So the error bar is now connecting the axis to the point rather than the point to the axis. Cheers Andy rvExcelNewTip wrote: I tried the error bar approach because it looked the simplest and most straightforward . But I'm now stuck with the following snag: The Y-axis has a logarithmic scale and whatever I try, I cannot get an error bar DOWN from the data point to the X-axis! I specified a value of 100% for the error, or alternatively I tried to Customize with the Negative Y-value (workshell location of Y value) but to no avail. If I selected Both (to have the error bar extended on both sides of the data point) only the upper part showed up! I'm working with Excel 2003. Is this a bug or does it "works as designed"? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#7
|
|||
|
|||
Scatter Chart Data Point Highlighting
That's cool Andy! But do you have any eplanation for Excel's native behaviour? -- rvExcelNewTip ------------------------------------------------------------------------ rvExcelNewTip's Profile: http://www.excelforum.com/member.php...o&userid=15668 View this thread: http://www.excelforum.com/showthread...hreadid=498625 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Height (in points) of data point in chart above x-axis | Scott P | Charts and Charting | 5 | November 13th, 2005 01:56 AM |
Scatter Chart data | rfronk | Charts and Charting | 5 | June 18th, 2005 01:20 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Help with data not getting plotted | Scott Ehrlich | Charts and Charting | 1 | January 23rd, 2005 05:15 PM |
Data labels in scatter charts | Joshua | Charts and Charting | 1 | April 17th, 2004 06:55 PM |