Excel Graphs

[mossbs]

Hi guys,

Trying to do a scattergraph for a survey that was sarried out on member benefits and the awareness and importance of them. so there are, as such, 3 variables

- the benefit
- awareness (%)
- importance (%)

how can i plot awareness against importance and then have the 'benefit' as the data label?

I have tried a couple of times, but cant seem to get it right.

Cheers,

Dan

 

[SkipVought]

I have an Add-In that I got from

http://www.j-walk.com

for Chart Tools. You can "attach" labels to any series in your chart. Otherwise you'll have to write a VBA (maceo) to do that.

Your chart lends itself to a Quadrent scatter chart where...
[tt]
HIGH |HIGH |
Importance |Importance |
LOW |HIGH |
Awareness |Awareness |
-------------+-------------+
LOW |LOW |
Importance |Importance |
LOW |HIGH |
Awareness |Awareness |
[/tt]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[dallen43]

Dan,

I'm not sure if you have already figured it out or not.
But following is the way I found to do it. It is rather manual.

I created data as follows:

    A           B          C
1   Benefit     Awareness  Importance
2   Health      95         99
3   Dental      74         87
4   Vision      67         24
5   Disability  35         87
6   Parking     2          2

Select data from A1 thru C6.
Click Chart Wizard.
Select Scatter and click Next.

Select the Series Tab.
Remove Awareness and Importance.
Click Add.
Name = A2
X Value = B2
Y Value = C2
Continue to Add rows 3 through 6.
You should have 5 series: Health, Dental, Vision, Disability and Parking.

Click Next.
Titles Tab:
Chart Title: Benefits
Value (X) Axis: Awareness
Value (Y) Axis: Importance
Legend Tab:
Click Show Legend
Data Labels:
Click Series Name

Click Next
Indicate where you would like the chart.

This seems to work for me.

Hope this is what you needed.
Deb

 

[mossbs]

superb - cheers to both of you for your response have got it all sorted now.(im a sql bodd... not a excel person!!)

ended up going the manual way - its easier to show the membership team how to do it like this.

cheers again guys

dan