Skip to Content
0
Former Member
Nov 15, 2013 at 02:57 PM

Column chart does not auto arrange and stacked together

15 Views

I am creating a column chart on the base of my year and monthly values. I use a toggle button with it to toggle between year and month. I use formulas and it works fine. When I map chart and preview the report all columns are stacked together on the left. I have checked ignore blank cells in series and values. See the screen short attached. If I use the cells where I have not written any formulas then it is ok. I have written formulas so that I may do some calculation to get yearly and monthly data and avoid some blanks in data. I appreciate help Thanks

Attachments

Chart Erro1.jpg (30.7 kB)