I am new to Xcelsius and I am stuck while working on a combination chart with 2 series. The X axis for the graph should be dynamic based on the selection available.
So the graph should show data for previous 13 months and prev 13 weeks at a time based on the filters given.
The 2 diff series show data for:
1.series 1 is for YTD(say Dec 12-Dec13, with labels as Dec'12,Jan'12,Feb'12.............................Dec'13 etc for prev 13 months)
2.the other series will be showing week values (10/1,10/8...12/31 for 13 weeks)
Is there a way to show the X axis dy X axis dynamic, since
the data format in the excel can be fixed to only one type say if I fix it to MMM'YY format , then when I select the week series it shows week also as Oct-13 instead of 10/1 which is actually 1st Oct.
Can I get some help on this as soon as possible.😕
Thanks in advance
Khushboo😊