1 Reply Latest reply on Apr 23, 2012 9:32 AM by Tracy Rodgers

    Multiple measures on secondary axis - proposed workaround doesnt fit

    Minas Papageorgiou

      I have 6 measures. Three are monthly and three are YTD

      As such, the monthly are on a different scale than the YTD.

       

       

      I need to display in bars the current month, previous year month and current month target

      In lines the YTD Sales, Previous YTD and YTD Budget.

       

      When I followed the proposal with the A,B,C,D, by manupulating the data, I have the following problem:

       

      The three bars of the current month overlap. The second image (Excel Chart) shows my final objective..

       

      Current.pngtarget.jpg