Urgent, please help... should be ez for u excel 'xperts!

Feb 18th, 2002, 08:01 AM

Hello... I need to create a graph as follows...

VERY
HIGH *

HIGH * *

MED *

LOW
LOW MED HIGH VERY HIGH

The problem is, I don't really know how to enter the values in a table.....
and how do I get low to represent say, 1 and med 2 high 3 very high 4... so that the graph can be shown?
Help a newbie to excel.. thanks!

Pier.

Feb 18th, 2002, 08:02 AM

Sorry.. the dots are not aligned correctly with the columns.....
but I think u should get my idea.. thanks.

Pier.

Jack in the UK · Feb 18th, 2002, 12:03 PM

HI--

Sounds like first you need to set out another sheet to convert values that you have into High Med Low and so on then make the graph - suggest wizar and edit / custom as required.

To return text need IF formula and work from there.

HTH
Rdgs
==========
Jack

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 18th, 2002, 08:01 AM	#1
Guest Posts: n/a	Hello... I need to create a graph as follows... VERY HIGH * HIGH * * MED * LOW LOW MED HIGH VERY HIGH The problem is, I don't really know how to enter the values in a table..... and how do I get low to represent say, 1 and med 2 high 3 very high 4... so that the graph can be shown? Help a newbie to excel.. thanks! Pier.

Feb 18th, 2002, 08:02 AM	#2
Guest Posts: n/a	Sorry.. the dots are not aligned correctly with the columns..... but I think u should get my idea.. thanks. Pier.

Feb 18th, 2002, 12:03 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	HI-- Sounds like first you need to set out another sheet to convert values that you have into High Med Low and so on then make the graph - suggest wizar and edit / custom as required. To return text need IF formula and work from there. HTH Rdgs ========== Jack