Chart --> Source Data... --> Series dialog window


G

Guest

On the Source Data --> Series dialog window in MS Excel 2003 , the
marker_order_number is the only piece of a series formula

=SERIES("series_name",
worksheet_name!category_reference,worksheet_name!values_reference,marker_order_number)

that is not available for editing. Selecting a series on the chart can
often be very difficult if the values are zero or very small relative to the
values in the other series, so I regularly edit series formulas via the
Source Data --> Series dialog window. As it is currently, the only way to
change the display order for multiple series is to select a series on the
chart so that the series formula is displayed in the formula bar and then
manually edit the formula for each series that needs to move. I would like
to be able to edit the marker_order_number by selecting a series on the
Source Data --> Series dialog window and then clicking a "Move Up" or "Move
Down" button. This would be especially helpful when working with 10 or more
series. (By the way, I have charts with 25, 102, and 120 series.)



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...c34d97de36&dg=microsoft.public.excel.charting
 
Ad

Advertisements

A

Andy Pope

Hi,

You are aware that the "Move up" and "Move down" option is available on
Series Order tab of the Format dialog. Just double click a series to
bring up the dialog. You can change the order of all, similar chart type
within the same axis, group at once.

Cheers
Andy
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top