Welcome to the Excel Forum

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.

Excel Help Forum » Microsoft Office Application Help - Excel Help forum » Excel Programming » Excel Charting » Clustered Column Chart question

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 07-29-2009, 05:47 PM
zqipper zqipper is offline
Registered User
  
Join Date: 29 Jul 2009
Location: Rochester, NY
MS Office Version:Excel 2003
Posts: 1
zqipper is becoming part of the community
Clustered Column Chart question

Please Register to Remove these Ads

Hi. I'm creating a clustered column chart in Excel 2003 and I have a different number of elements in different clusters. For example, for the cluster "CL-572" I want to see 6 columns, but for the cluster "CL-571" I only want three columns. The way I have the spreadsheet set up, Excel infers a value of 0 for each blank so that in clusters with fewer than six entries, the columns are spaced out because it assumes that there is a "0 column" in there somewhere. Can I tell Excel that when there are blanks in the spreadsheet, the chart should omit the column rather than plot a 0? Thank you.
Reply With Quote
  #2  
Old 07-30-2009, 02:33 AM
DonkeyOte's Avatar
DonkeyOte DonkeyOte is offline
Forum Guru
  
Join Date: 22 Oct 2008
Location: Suffolk, UK
MS Office Version:2002 & 2007
Posts: 13,665
DonkeyOte has a reputation beyond repute DonkeyOte has a reputation beyond repute DonkeyOte has a reputation beyond repute DonkeyOte has a reputation beyond repute DonkeyOte has a reputation beyond repute DonkeyOte has a reputation beyond repute DonkeyOte has a reputation beyond repute DonkeyOte has a reputation beyond repute DonkeyOte has a reputation beyond repute DonkeyOte has a reputation beyond repute DonkeyOte has a reputation beyond repute
Re: Clustered Column Chart question
thread moved to Charting forum
Reply With Quote
  #3  
Old 07-30-2009, 05:33 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Guru
  
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,223
Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding
Re: Clustered Column Chart question
If you could that would mean the width of a column across clusters would vary.
This would then imply the width of the column had some relevance.

If you only have 2 clusters then it may be possible by using the secondary axis and some careful laying out of your data.

You could also try using the technique for creating variable width columns.
http://www.andypope.info/charts/colwidth2.htm
__________________
Cheers
Andy
www.andypope.info
Reply With Quote


Reply

Bookmarks

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off
Forum Jump

Contact Us - ExcelTip.com - Archive - Top