Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() 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 |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data showing incorrectly on line chart | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
changing proportion of chart and data table | Charts and Charting in Excel |