disproportionate piled column charts!!!

L

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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Sort by date Sort by votes
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?
 
Upvote 0
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?
 
Upvote 0
It's probably something about the chart set up, such as having the data series in rows rather than columns, I would guess.
 
Upvote 0
I don't know without seeing the workbook, I'm afraid.
 
Upvote 0
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.
 
Upvote 0
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!
 
Upvote 0
You must log in or register to reply here.

Similar threads

O
  • Question
Creating a Graph/Chart needing TWO secondary axis options for a combination of Clustered and Stacked Graph Columns
Replies
0
Views
276
OrangeJuice
O
R
  • Question
Formatting data series for chart created via Slicer and Pivot Table
Replies
6
Views
256
awoohaw
awoohaw
N
  • Question
Stacked Chart to show value and status YTD
Replies
2
Views
268
neilo1969
N
N
  • Question
2-step Dynamic Ranges and Charts
Replies
0
Views
114
Nick Loughton
N
Y
  • Question
Chart only part of a table
Replies
1
Views
258
NdNoviceHlp
NdNoviceHlp

Forum statistics

Threads
1,214,375
Messages
6,119,170
Members
448,870
Latest member
max_pedreira

Share this page

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
Back
Top