Skip to Content
Former Member
Aug 23, 2013 at 06:07 AM

Fixing the x-axis, not to be dynamic



I am reading component values from BIWS-Webi into dashboard. The problem i am facing is the x-axis values keeps changing every year. How to make it static so that i can show constant values every year.

For example there are six program names - A, B, C,D,E,F and for year 2011 webi will have values for A,B,C,D and for year 2010 webi will have values only for C and D. When i plot a bar chart with 2011 vs 2010, i see C and D values jumping in the A, B place. I need to display all A, B, C,D,E,F in the chart and where ever values are missing it should show zero or N/A.

Anyways to do it in the Xcelsius spreadsheet? I tried with nested if loop but xcelsius have some limitations in the number of nested loops.

Appreciate your help.