on 11-15-2013 2:57 PM
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
Hi Bashir
I can't see the screenshot. Are you replacing blank with zero? If so, you may wanna leave the blanks values blank so that "Ignore Blank" option can hide them and auto-arrange. But i will be able to suggest better when I see the screenshot.
Runali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.