software

Hello,

When I make a 3D surface chart in Excel, the 'series axis' is automatically
displayed as S1, S2, etc. How can I have that axis display numbers?

My table is in the following form:
5 10 15
2 45 48 62
4 35 34 60
6 12 13 58

When I make my surface chart, I select all the cells for the data range
(including the top left blank one) and select series in columns but Excel
does not change the series in numbers automatically (Series1, Series2 and
Series3 are displayed instead of 5, 10 and 15). For example Series2 includes
5, 45, 35, 12 (but it should include 45, 35, 12) and the Name cell is empty.

How can I make Excel to display numbers instead of series automatically
(without having to select all the cells manually)?

Thank you for your help,

S.Grossmann
I cannot reproduce this problem in XL2003 - my chart has 5, 10,15 on the
axis.
However, you could type typing '5, '10, '15 That is to say, use text rather
than numbers.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;S.Grossmannquot; gt; wrote in message
...
gt; Hello,
gt;
gt; When I make a 3D surface chart in Excel, the 'series axis' is
gt; automatically displayed as S1, S2, etc. How can I have that axis display
gt; numbers?
gt;
gt; My table is in the following form:
gt; 5 10 15
gt; 2 45 48 62
gt; 4 35 34 60
gt; 6 12 13 58
gt;
gt; When I make my surface chart, I select all the cells for the data range
gt; (including the top left blank one) and select series in columns but Excel
gt; does not change the series in numbers automatically (Series1, Series2 and
gt; Series3 are displayed instead of 5, 10 and 15). For example Series2
gt; includes 5, 45, 35, 12 (but it should include 45, 35, 12) and the Name
gt; cell is empty.
gt;
gt; How can I make Excel to display numbers instead of series automatically
gt; (without having to select all the cells manually)?
gt;
gt; Thank you for your help,
gt;
gt; S.Grossmann
gt;
gt;
Hi,

I could only replicate your problem when the top left cell was not empty.
You can use the source data dialog to add series names and category labels.

Cheers
Andy

S.Grossmann wrote:
gt; Hello,
gt;
gt; When I make a 3D surface chart in Excel, the 'series axis' is automatically
gt; displayed as S1, S2, etc. How can I have that axis display numbers?
gt;
gt; My table is in the following form:
gt; 5 10 15
gt; 2 45 48 62
gt; 4 35 34 60
gt; 6 12 13 58
gt;
gt; When I make my surface chart, I select all the cells for the data range
gt; (including the top left blank one) and select series in columns but Excel
gt; does not change the series in numbers automatically (Series1, Series2 and
gt; Series3 are displayed instead of 5, 10 and 15). For example Series2 includes
gt; 5, 45, 35, 12 (but it should include 45, 35, 12) and the Name cell is empty.
gt;
gt; How can I make Excel to display numbers instead of series automatically
gt; (without having to select all the cells manually)?
gt;
gt; Thank you for your help,
gt;
gt; S.Grossmann
gt;
gt;

--

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

Thanks for the tip. Excel displays now correctly 5, 10, 15 in the Series
field instead of Series1, Series2, ...

I cannot understand why it not working without this trick on my computer. It
looks like a bug. I am using Excel 2003 SP2.

Kind regards,

S.Grossmann

quot;Bernard Liengmequot; gt; wrote in message
...
gt;I cannot reproduce this problem in XL2003 - my chart has 5, 10,15 on the
gt;axis.
gt; However, you could type typing '5, '10, '15 That is to say, use text
gt; rather than numbers.
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;S.Grossmannquot; gt; wrote in message
gt; ...
gt;gt; Hello,
gt;gt;
gt;gt; When I make a 3D surface chart in Excel, the 'series axis' is
gt;gt; automatically displayed as S1, S2, etc. How can I have that axis display
gt;gt; numbers?
gt;gt;
gt;gt; My table is in the following form:
gt;gt; 5 10 15
gt;gt; 2 45 48 62
gt;gt; 4 35 34 60
gt;gt; 6 12 13 58
gt;gt;
gt;gt; When I make my surface chart, I select all the cells for the data range
gt;gt; (including the top left blank one) and select series in columns but Excel
gt;gt; does not change the series in numbers automatically (Series1, Series2 and
gt;gt; Series3 are displayed instead of 5, 10 and 15). For example Series2
gt;gt; includes 5, 45, 35, 12 (but it should include 45, 35, 12) and the Name
gt;gt; cell is empty.
gt;gt;
gt;gt; How can I make Excel to display numbers instead of series automatically
gt;gt; (without having to select all the cells manually)?
gt;gt;
gt;gt; Thank you for your help,
gt;gt;
gt;gt; S.Grossmann
gt;gt;
gt;gt;
gt;
gt;
Thanks! It is working now! The top left cell looked empty but it was not. I
pressed the Delete button on the keyboard, tried again and the axis is now
displayed with numbers.

Best regards,
S.Grossmann

quot;Andy Popequot; gt; wrote in message
...
gt; Hi,
gt;
gt; I could only replicate your problem when the top left cell was not empty.
gt; You can use the source data dialog to add series names and category
gt; labels.
gt;
gt; Cheers
gt; Andy
gt;
gt; S.Grossmann wrote:
gt;gt; Hello,
gt;gt;
gt;gt; When I make a 3D surface chart in Excel, the 'series axis' is
gt;gt; automatically displayed as S1, S2, etc. How can I have that axis display
gt;gt; numbers?
gt;gt;
gt;gt; My table is in the following form:
gt;gt; 5 10 15
gt;gt; 2 45 48 62
gt;gt; 4 35 34 60
gt;gt; 6 12 13 58
gt;gt;
gt;gt; When I make my surface chart, I select all the cells for the data range
gt;gt; (including the top left blank one) and select series in columns but Excel
gt;gt; does not change the series in numbers automatically (Series1, Series2 and
gt;gt; Series3 are displayed instead of 5, 10 and 15). For example Series2
gt;gt; includes 5, 45, 35, 12 (but it should include 45, 35, 12) and the Name
gt;gt; cell is empty.
gt;gt;
gt;gt; How can I make Excel to display numbers instead of series automatically
gt;gt; (without having to select all the cells manually)?
gt;gt;
gt;gt; Thank you for your help,
gt;gt;
gt;gt; S.Grossmann
gt;gt;
gt;gt;
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info