software

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

=SERIES(quot;series_namequot;,
worksheet_name!category_reference,worksheet_name!v alues_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 --gt; 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 --gt; Series dialog window and then clicking a quot;Move Upquot; or quot;Move
Downquot; 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 quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...excel.charting

Hi,

You are aware that the quot;Move upquot; and quot;Move downquot; 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

Sarah Jane wrote:
gt; On the Source Data --gt; Series dialog window in MS Excel 2003 , the
gt; marker_order_number is the only piece of a series formula
gt;
gt; =SERIES(quot;series_namequot;,
gt; worksheet_name!category_reference,worksheet_name!v alues_reference,marker_order_number)
gt;
gt; that is not available for editing. Selecting a series on the chart can
gt; often be very difficult if the values are zero or very small relative to the
gt; values in the other series, so I regularly edit series formulas via the
gt; Source Data --gt; Series dialog window. As it is currently, the only way to
gt; change the display order for multiple series is to select a series on the
gt; chart so that the series formula is displayed in the formula bar and then
gt; manually edit the formula for each series that needs to move. I would like
gt; to be able to edit the marker_order_number by selecting a series on the
gt; Source Data --gt; Series dialog window and then clicking a quot;Move Upquot; or quot;Move
gt; Downquot; button. This would be especially helpful when working with 10 or more
gt; series. (By the way, I have charts with 25, 102, and 120 series.)
gt;
gt;
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...excel.charting

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

No, I wasn't aware of that location. Thanks so much.

quot;Andy Popequot; wrote:

gt; Hi,
gt;
gt; You are aware that the quot;Move upquot; and quot;Move downquot; option is available on
gt; Series Order tab of the Format dialog. Just double click a series to
gt; bring up the dialog. You can change the order of all, similar chart type
gt; within the same axis, group at once.
gt;
gt; Cheers
gt; Andy
gt;
gt; Sarah Jane wrote:
gt; gt; On the Source Data --gt; Series dialog window in MS Excel 2003 , the
gt; gt; marker_order_number is the only piece of a series formula
gt; gt;
gt; gt; =SERIES(quot;series_namequot;,
gt; gt; worksheet_name!category_reference,worksheet_name!v alues_reference,marker_order_number)
gt; gt;
gt; gt; that is not available for editing. Selecting a series on the chart can
gt; gt; often be very difficult if the values are zero or very small relative to the
gt; gt; values in the other series, so I regularly edit series formulas via the
gt; gt; Source Data --gt; Series dialog window. As it is currently, the only way to
gt; gt; change the display order for multiple series is to select a series on the
gt; gt; chart so that the series formula is displayed in the formula bar and then
gt; gt; manually edit the formula for each series that needs to move. I would like
gt; gt; to be able to edit the marker_order_number by selecting a series on the
gt; gt; Source Data --gt; Series dialog window and then clicking a quot;Move Upquot; or quot;Move
gt; gt; Downquot; button. This would be especially helpful when working with 10 or more
gt; gt; series. (By the way, I have charts with 25, 102, and 120 series.)
gt; gt;
gt; gt;
gt; gt;
gt; gt; ----------------
gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; click quot;I Agreequot; in the message pane.
gt; gt;
gt; gt; www.microsoft.com/office/comm...excel.charting
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info
gt;