Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data showing incorrectly on line chart gobonniego Charts and Charting in Excel 1 June 15th 06 07:56 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Help with data not getting plotted Scott Ehrlich Charts and Charting in Excel 1 January 23rd 05 05:15 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
changing proportion of chart and data table Dawn Parks Charts and Charting in Excel 3 January 6th 05 01:18 AM


All times are GMT +1. The time now is 10:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"