How to Make stacked bar a column of dates?

[luiscarlosh]

I have a chart with 2 columns: dates (from 1 to 31 of the month) and amounts (amounts that are recorded during the month in several days). The dates are repeated if more than an allocated amount in the days of the month.

When I generate the chart, are the dates on the bottom, summarized by day ...
My problem is that Excel did not stack the numbers of each day clustered on one another. Puts one by one starting from zero, but not above the other.

How do you stack up on each other? Remember we are talking about a single column and a single amounts of dates.

Example of the problem: http://prntscr.com/1lam0z


In the screeh shot we can see the sumarized day 3/02/2013 with the max heigth 500, instead 750, because are 2 numers sumarized... 500 and 250

How do I stack one obove the other?

[Steve=True]

Hi Luis,

You have not chosen a stacked chart type. So your data is just one in front of another. However, your data is not laid out right for a stacked column chart.

You will need to change the way your data is laid out.

Check out this new sample to see what I mean. Alternately, I have changed your original chart to a Text Horizontal Axis so that you can see what it looks like when you don't Excel thinks your axis is individual values and not dates.

sample2 - stacked columns.xlsx

Let me know if this helps.

Steve=True

[luiscarlosh]

Thanks very much. Is an excelent Idea.

Then I need to set the amount in landscape direction...

My problem is that the Columns normaly are capured down, some times 500 rows in moth! About 16 rows by day date...

I would need to create aother page and send it Unique Dates of monht, and capture the 16 data amount in landscape by date

Im going to need a VBA code to do this...

Hi Luis,

You have not chosen a stacked chart type. So your data is just one in front of another. However, your data is not laid out right for a stacked column chart.

You will need to change the way your data is laid out.

Check out this new sample to see what I mean. Alternately, I have changed your original chart to a Text Horizontal Axis so that you can see what it looks like when you don't Excel thinks your axis is individual values and not dates.

Attachment 257940

Let me know if this helps.

Steve=True