Scatter Chart with non-numeric values on X axis

P

penasm

Hi,

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

Thx
 
A

Andy Pope

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
 

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

Similar Threads

Make Y-axis values correspond to x- axis value 1
Scatter chart with categories on x-Axis 2
Gantt chart duration not showing 0
Use text descriptors as Y axis units 1
Can I use non-numeric x axis data in excel charts? 2
Nameing scattered data in chart (dot's) 10
Line Chart - Problems with labeling X-Axis 3
Chart with differing x axis 1

Top