A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

need help with an interesting chart



 
 
Thread Tools Display Modes
  #1  
Old September 23rd, 2009, 05:53 PM posted to microsoft.public.excel.charting
jwhigham
external usenet poster
 
Posts: 2
Default need help with an interesting chart

Excel 2007 - I have a hard copy of a chart I need to recreate, but I don't
know how it was created. It looks like a normal data table, but the columns
all show a weighted bar along with the text. The bars represent the
percentage of each item compared to the total of that column. Anyone familiar
with this kind of chart?
Ads
  #2  
Old September 23rd, 2009, 06:11 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default need help with an interesting chart

Is it a 100% stacked column chart?

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



jwhigham wrote:
Excel 2007 - I have a hard copy of a chart I need to recreate, but I don't
know how it was created. It looks like a normal data table, but the columns
all show a weighted bar along with the text. The bars represent the
percentage of each item compared to the total of that column. Anyone familiar
with this kind of chart?

  #3  
Old September 23rd, 2009, 06:19 PM posted to microsoft.public.excel.charting
jwhigham
external usenet poster
 
Posts: 2
Default need help with an interesting chart

No. It looks more like this, but each cell has a bar next to the data that
varies in length depending on the number associated with it.
Number of Shipments Weight (tons)
Customer 1 11.209 66.224
Customer 2 23.281 67.584
Customer 3 3.214 11.479

"Jon Peltier" wrote:

Is it a 100% stacked column chart?

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



jwhigham wrote:
Excel 2007 - I have a hard copy of a chart I need to recreate, but I don't
know how it was created. It looks like a normal data table, but the columns
all show a weighted bar along with the text. The bars represent the
percentage of each item compared to the total of that column. Anyone familiar
with this kind of chart?


  #4  
Old September 24th, 2009, 05:14 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default need help with an interesting chart

Excel 2007 has a conditional formatting feature called Data Bars, which
draws bars in the cells. Look on the ribbon or in the help files for
'Data Bars'.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



jwhigham wrote:
No. It looks more like this, but each cell has a bar next to the data that
varies in length depending on the number associated with it.
Number of Shipments Weight (tons)
Customer 1 11.209 66.224
Customer 2 23.281 67.584
Customer 3 3.214 11.479

"Jon Peltier" wrote:

Is it a 100% stacked column chart?

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



jwhigham wrote:
Excel 2007 - I have a hard copy of a chart I need to recreate, but I don't
know how it was created. It looks like a normal data table, but the columns
all show a weighted bar along with the text. The bars represent the
percentage of each item compared to the total of that column. Anyone familiar
with this kind of chart?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.