Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 19
Default Show series name on the chart - but not at every data point

I want to show the name of the data series on the chart - but only once. If
I check "Series name" in the "Format data series" "Data Labels" tab - then it
shows at every data point - I only want it at e.g. the last.

How is that done?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Show series name on the chart - but not at every data point

To show the name of the data series on the chart, but only once, you can follow these steps:
  1. Click on the chart to select it.
  2. Click on the data series that you want to label.
  3. Right-click on the data series and select "Add Data Labels".
  4. Right-click on the data labels and select "Format Data Labels".
  5. In the "Label Options" section, check the box next to "Series Name".
  6. In the "Label Position" section, select "Outside End".
  7. In the "Label Contains" section, select "Value From Cells".
  8. Click on the "Select Range" button and select the cell that contains the name of the data series.
  9. Click "OK" to close the "Format Data Labels" dialog box.

This will add the name of the data series to the last data point in the series. If you want to change the position of the label, you can drag it to a different location on the chart.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Show series name on the chart - but not at every data point

Hi,

To do this manually first select the series and then select the individual
point. Now apply data labels.

With VBA code have a look at Jon Peltier's page
http://peltiertech.com/Excel/Charts/LabelLastPoint.html

With dummy data series see
http://www.andypope.info/charts/Labellast.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"RSunday" wrote in message
...
I want to show the name of the data series on the chart - but only once.
If
I check "Series name" in the "Format data series" "Data Labels" tab - then
it
shows at every data point - I only want it at e.g. the last.

How is that done?


  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 19
Default Show series name on the chart - but not at every data point

Thanks Andy,

your step-by-step guide is very good - but for my purpose I just want to do
the individual series manually.

But how exactly do I "select the individual point" and "apply the data
label"? When I click the last point - the format menu for the entire series
pops up.

"Andy Pope" wrote:

Hi,

To do this manually first select the series and then select the individual
point. Now apply data labels.

With VBA code have a look at Jon Peltier's page
http://peltiertech.com/Excel/Charts/LabelLastPoint.html

With dummy data series see
http://www.andypope.info/charts/Labellast.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"RSunday" wrote in message
...
I want to show the name of the data series on the chart - but only once.
If
I check "Series name" in the "Format data series" "Data Labels" tab - then
it
shows at every data point - I only want it at e.g. the last.

How is that done?


  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Show series name on the chart - but not at every data point

Hi,

You need to do it with two clicks. First click will select the series. The
second click should be the data point you want the data label applied to.
You could try using the keyboard if that makes it easier.
http://www.andypope.info/tips/tip003.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"RSunday" wrote in message
...
Thanks Andy,

your step-by-step guide is very good - but for my purpose I just want to
do
the individual series manually.

But how exactly do I "select the individual point" and "apply the data
label"? When I click the last point - the format menu for the entire
series
pops up.

"Andy Pope" wrote:

Hi,

To do this manually first select the series and then select the
individual
point. Now apply data labels.

With VBA code have a look at Jon Peltier's page
http://peltiertech.com/Excel/Charts/LabelLastPoint.html

With dummy data series see
http://www.andypope.info/charts/Labellast.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"RSunday" wrote in message
...
I want to show the name of the data series on the chart - but only
once.
If
I check "Series name" in the "Format data series" "Data Labels" tab -
then
it
shows at every data point - I only want it at e.g. the last.

How is that done?



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
regarding allocation of chart series point colors David Charts and Charting in Excel 2 October 27th 06 09:18 AM
Series point on a chart Anthony Blackburn Excel Discussion (Misc queries) 2 August 7th 06 04:26 PM
How do I show the maximum point on a scatterplot chart? Chief Charts and Charting in Excel 2 April 8th 05 03:47 PM
show the value of the last point of every series, in Excel line ch assaf Charts and Charting in Excel 3 February 20th 05 07:15 AM
On a scatter chart show two point have same value Maz Page Charts and Charting in Excel 1 December 16th 04 01:00 PM


All times are GMT +1. The time now is 08:35 AM.

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

About Us

"It's about Microsoft Excel"