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



Quote Originally Posted by Steve=True View Post
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