Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create a comparison chart from a data list?
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 |
#2
|
|||
|
|||
I don't know if this will work for you? Just a suggestion. +-------------------------------------------------------------------+ |Filename: Services.zip | |Download: http://www.excelforum.com/attachment.php?postid=3830 | +-------------------------------------------------------------------+ -- DCSwearingen ------------------------------------------------------------------------ DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506 View this thread: http://www.excelforum.com/showthread...hreadid=468211 |
#3
|
|||
|
|||
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/ _______ DCSwearingen wrote: I don't know if this will work for you? Just a suggestion. +-------------------------------------------------------------------+ |Filename: Services.zip | |Download: http://www.excelforum.com/attachment.php?postid=3830 | +-------------------------------------------------------------------+ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a Pie Chart from a LIST of Data? | Charts and Charting in Excel | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |