disproportionate piled column charts!!!

lu_argenitna

Board Regular
Joined
Apr 4, 2006
Messages
106
Hi! i'm having some trouble with piled column charts (the second option of column charts).
I have a simple chart of piled columns. I created the chart to show in a same column 1200 and 30000, so the size of the second block should be much bigger, but it's not!!! If i change the series order, it's correct, but all the other charts are in other order, so I don't want to change it!
I'm using excel 2003.
Any comments?
thanks!!!
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,801
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
I would have to guess that it is not plotting what you think it is plotting. Can you give us an idea of your data layout?
 

lu_argenitna

Board Regular
Joined
Apr 4, 2006
Messages
106
I can't share the information because it's confidential. When I copied to another workbook to share it without the names and do the chart again, it does it correctly!! So I guess it's something on the other file. Maybe because it's too heavy and with many numbers?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,801
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
It's probably something about the chart set up, such as having the data series in rows rather than columns, I would guess.
 

lu_argenitna

Board Regular
Joined
Apr 4, 2006
Messages
106

ADVERTISEMENT

yes, I do have it in rows, but it's not a problem for the other charts! why does this happen?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,801
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
I don't know without seeing the workbook, I'm afraid.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,801
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Your value axis seems to have gone a little mad - it is only displaying from about 33,000 upwards, so you are only seeing the top of the larger column. If you show the axis, set the minimum value to 0 and then clear the axis again, your chart should look fine.
 

lu_argenitna

Board Regular
Joined
Apr 4, 2006
Messages
106
I can't believe it was so easy!! I don't know why it takes that as the minimum because it's automatic, I haven't touch it!!!
thanks a lot!! this was anoying me!
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,195
Messages
5,835,918
Members
430,394
Latest member
Ace_Quared

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top