Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
 
Posts: n/a
Default How to select data series to format? (alternative needed)

Is there an alternate way to select a data series to format
in an XY Scatter chart?

The only way I know of is to move the cursor close to the
series line and right-click.

But if the chart includes many data series and the lines
are close together, it is difficult, if not "impossible", to
select the desired line.

I am looking for a method that presents me with a list
of all the data series, and I select the one I want to
"right click" (i.e. open the menu that include format,
add trendline and clear, among others).

Or something else that would not be so difficult to use.
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default How to select data series to format? (alternative needed)

Hi,

You can use the cursor keys to cycle through the chart elements. More
explanation can be found here.
http://www.andypope.info/tips/tip003.htm

One you have the correct element selected use CTRL+1 to display the
format dialog. Or use the Format menu.

The chart toolbar include a dropdown list of chart elements which will
select the choosen item. To display the chart toolbar either right-click
a toolbar to display a popup of available toolbars or use the menu View
Toolbars Chart


Cheers
Andy

wrote:
Is there an alternate way to select a data series to format
in an XY Scatter chart?

The only way I know of is to move the cursor close to the
series line and right-click.

But if the chart includes many data series and the lines
are close together, it is difficult, if not "impossible", to
select the desired line.

I am looking for a method that presents me with a list
of all the data series, and I select the one I want to
"right click" (i.e. open the menu that include format,
add trendline and clear, among others).

Or something else that would not be so difficult to use.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Posted to microsoft.public.excel.charting
 
Posts: n/a
Default How to select data series to format? (alternative needed)

"Andy Pope" wrote:
You can use the cursor keys to cycle through the chart
elements. More explanation can be found here.
http://www.andypope.info/tips/tip003.htm
One you have the correct element selected use CTRL+1
to display the format dialog. Or use the Format menu.


Terrific! Thanks much.
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
Adding data series to chart via macro JessK Charts and Charting in Excel 1 March 2nd 06 12:04 AM
Chart -- Source Data... -- Series dialog window Sarah Jane Charts and Charting in Excel 2 January 24th 06 11:27 AM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
Excel should let me align data labels in different series (Excel . dlearndeltondo Charts and Charting in Excel 0 February 10th 05 09:45 PM


All times are GMT +1. The time now is 08:30 PM.

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

About Us

"It's about Microsoft Excel"