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!!!
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
36,066
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
36,066
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
36,066
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
36,066
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,469
Messages
5,596,314
Members
414,053
Latest member
Dual Showman

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