5 Replies Latest reply on Oct 3, 2012 10:38 AM by Ralph Lindenfeld

    sort order, space between columns

    Ralph Lindenfeld



      I need to create a space between annual and YTD columns in one graph. (see attached). So the data is currently manually sorted, with an empty data cell and column between the annual and YTD columns.


      However, when I change data, as will happen with quarterly updates, the sort is lost and the new data is added to the end.


      If I set sort to "data source order",  the empty cell is added to the beginning of the data set.


      How can I get a persistent gap between the data?