Scatter Chart with non-numeric values on X axis

Hi,

I'm trying to figure out how to create a scatter chart (graph) with
words for the x axis. I'm trying to setup a graph showing availability
of servers, so for the Y axis I want to show a percentage (between
1-100%), and for the X axis, I want to show the name of the service
(mail, news, etc). However, it seems that with a scatter chart I can
only do numeric values on both axis. Is there any way around this?

Thx.


--
penasm
------------------------------------------------------------------------
penasm's Profile: http://www.excelforum.com/member.php...o&userid=15832
View this thread: http://www.excelforum.com/showthread...hreadid=273234

Hi,

Use the line chart. This will give you x axis categorys and values up
the y axis. The format the data series and set the line type to None.

Although I would have thought a simple column chart was best suited to
your data.

Cheers
Andy

penasm wrote:

Hi,

I'm trying to figure out how to create a scatter chart (graph) with
words for the x axis. I'm trying to setup a graph showing availability
of servers, so for the Y axis I want to show a percentage (between
1-100%), and for the X axis, I want to show the name of the service
(mail, news, etc). However, it seems that with a scatter chart I can
only do numeric values on both axis. Is there any way around this?

Thx.



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info