Excel Chart - multi attribute

How does one create a chart for multi attribute ?

I have three company and I am comparing them with two attributes. I want a chart (bubbel/scatter?) not really sure what kind.

Company A 200,80
Company B 700,80
Company C 500,10

So the 200-700 (doesnt matter if x,y axis) would be one attribute
10-80 would be the other.

how can I do this correctly?

THanks,
SJMP
sparkisAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jppintoCommented:
Please take a look at the attached file. There are 3 sample charts that you can build to compare the data.

Hope that one helps.

jppinto
SampleChart.xlsx
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

you can plot two numerical values with an XY chart. Arrange the data as in the attached sample, then select cells B1:C4 and click Insert - Scatter.  To label the data points with the company name, you can download the XY Chart Labeler, which is an immensely helpful tool.

If you have a third attribute, you can create a bubble chart, where the bubble size represents the numeric value of the third attribute.

Download here:http://www.appspro.com/Utilities/ChartLabeler.htm


cheers, teylyn
chart.xlsx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sparkisAuthor Commented:
Teylyn

Thanks - I know how to do scatter plots. but I am still dont know how to do the following.

The X Axis needs to represent the costs
The Y Axis needs to represent the quantity

What I need is one label on the graph for Comp A with their costs right or left, and quantity up/down. So there is only one marker on the graph for the company.  I know I am not making this clear.

But i need both attributes represented together as one mark on the graph. So if X Axis was cost and Y axis is quantity I have them intersecting in the middle of the range. Not at 0.

Right now I am getting three markers for each attribute totally 6. I need three. Sorry I know this is not clear.
sparkisAuthor Commented:
got it
thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.