Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm looking to create a custom axis for my chart and was wondering if anyone has any ideas?
Basically the x-axis should show Q1, Q2, Q3, Q4 of last year, and at the end of the axis it should also have the month selected of this year. I'm really not sure how to go about this. Any help would be much appreciated.
thanks in advance
it is a pretty freak:P idea but:
makew an iland table :
LOAD * INLINE [
dimension
q1
q2
q2
q2
actualmonth
];
paste dimension as your dimension and make an expression such as: if (dimension =q1, "set analysis", if(....))
Hi,
If the yaxis is sales (say in a bar chart), you can create 5 expressions with setanalysis. Name the expressions as Q1,Q2,..,CurrentMonth
That would do it.
Kiran.