|
How to bold/highlight data point in chart
I am creating a series of charts that look at public opinion over the years. I would like to be able to bold, highlight, i.e., in some way draw attention to, particular values in the chart. For example, the x-axis will run from 1972-2004 and I would like to draw attention to certain points on lines in the chart, e.g., the value for women in 1976, 1980 and/or the value for men in 1992, 1996, etc. Any ideas on how I might be able to accomplish this? Thanks so much for any suggestions. Hank -- HankGreene ------------------------------------------------------------------------ HankGreene's Profile: http://www.excelforum.com/member.php...o&userid=37512 View this thread: http://www.excelforum.com/showthread...hreadid=571627 |
How to bold/highlight data point in chart
You could select a single point (two clicks: one to select the series, the
next to select the point), then use CTRL+1 or the Format menu to format just the selected point. Make the marker larger or a bolder color. Add a data label; use one of the default options for what's displayed in the label, then edit the text of the label (again, two single clicks to select the individual label, and another to activate the cursor). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "HankGreene" wrote in message ... I am creating a series of charts that look at public opinion over the years. I would like to be able to bold, highlight, i.e., in some way draw attention to, particular values in the chart. For example, the x-axis will run from 1972-2004 and I would like to draw attention to certain points on lines in the chart, e.g., the value for women in 1976, 1980 and/or the value for men in 1992, 1996, etc. Any ideas on how I might be able to accomplish this? Thanks so much for any suggestions. Hank -- HankGreene |
How to bold/highlight data point in chart
Thanks much!! That did the trick. -Hank Jon Peltier Wrote: You could select a single point (two clicks: one to select the series, the next to select the point), then use CTRL+1 or the Format menu to format just the selected point. Make the marker larger or a bolder color. Add a data label; use one of the default options for what's displayed in the label, then edit the text of the label (again, two single clicks to select the individual label, and another to activate the cursor). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ -- HankGreene ------------------------------------------------------------------------ HankGreene's Profile: http://www.excelforum.com/member.php...o&userid=37512 View this thread: http://www.excelforum.com/showthread...hreadid=571627 |
| All times are GMT +1. The time now is 02:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com