Is it possible? A Chart with no numeric values

  • Thread starter Thread starter andy_dyer
  • Start date Start date
A

andy_dyer

Hi,

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

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

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

Please help me!! :confused: :confused: :confused
 
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 th
results scores that can be plotted but I am having difficulties gettin
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!!

And

Attachment filename: excel.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=47638
 
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
 
Back
Top