How do I create a comparison chart from a data list?

C

comic guy

I want to create a bar chart. On the left is a list of services. Each bar
represents a company. Each company will be shown in the chart to offer
services up to a certain point, so the bars will get increasingly longer
until you get to the bar for my company which shows the longest bar because
it offers the most services. Any idea how to structure my data to get this
type of chart?

-comic guy
 
J

Jon Peltier

Couldn't you describe it in text? Something simple like this:

List your data in a worksheet like this:

Services
My Company 18
Company D 10
Company C 7
Company B 4
Company A 3

Make sure the data is sorted in descending order. Select the data and
use the chart wizard (the chart icon on the Standard toolbar, or Insert
menu > Chart) to create a bar chart.

Look at that! Much less bandwidth and easier for anyone to read than
having to download, virus scan, unzip, and open an attached file.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating separate graphs for columns of data 1
How do you create a chart with varied width and length? 1
Problem building horizontal bar chart paired bars, centered on zer 2
bars on chart do not match data points 2
How do I display data in a bar charted rounded to thousands? 2
How do I create a scrolling line chart? 0
Employee Schedule not plotting properly - chart type / data series not correct 0
Combining Multiple-Color Data Series into One Bar Chart 0

Top