Is it possible? A Chart with no numeric values

Hi,

I wish to plot two text categories against each other using Excel, one
of the categories is technically a number but are number ranges
exported from Access i.e. "0-30", 31-60" etc

I have peoples names on the X axis and I wish to plot physical activity
levels pre, mid and post (displayed on a legend).

I cannot find any way of having the Y axis displaying anything other
than numbers!!

Please help me!!


---
Message posted from http://www.ExcelForum.com/

Andy -

You're close. Start with this data:

0-30 0
31-60 0
61-90 0
91-120 0
121-150 0
150+ 0

and construct a bar chart. Since it's all zeros, all you see are the
labels up the left axis. Copy this data:

Full Name Pre Levels Mid Levels Post Levels
Person 1 2.5 2.5 2.5
Person 2 2.5 0 2.5
Person 3 2.5 0 3.5
Person 4 0.5 0.5 0.5
Person 5 2.5 2.5 2.5
Person 6 0 0 0
Person 7 4.5 3.5 3.5
Person 8 2.5 2.5 2.5
Person 9 4.5 4.5 5.5

select the chart, choose Paste Special from the Edit menu, and add the
data as new series, categories in first column (do not replace existing
categories), names in first row. These hit the chart as more bar series.

Select any of the new series, choose Chart Type from the Chart menu,
select a Line style. Then select another and press the F4 key to repeat,
and continue this for the last series.

Now let's fix the axes. Double click the left hand axis, and on the
Scale tab, check Value Axis Crosses at Maximum Category. Double click
the right side axis and uncheck Value Axis Crosses at Maximum Category.
Double click the top axis, and on the Patterns tab, check None for Major
and Minor Tick Spacing and Tick Labels. Repeat this for the Right axis.
Select the legend, then select the "Series1" text label (from the dummy
series we used to create the chart), not the colored rectangle, and
press Delete to remove the label from the legend.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______


andy_dyer wrote:

Ok... making progress!!!

Thanks for your help!!

I have attached a copy of the spreadsheet, demonstrating my issues...

I have pre, mid and post results that I am plotting, I have given the
results scores that can be plotted but I am having difficulties getting
the dummy column recognised.

I wish to have the records at the side plotted (i.e. 0-30, 31-60 etc)
up the Y axis instead of the numbers.

Can this be done??

Once again thanks for your help!!

Andy

Attachment filename: excel.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=476383
---
Message posted from http://www.ExcelForum.com/