Added slice and then graphed new slice. Labels/axis shown reference the parent of the slice, not the data within the slice. Is this normal?
To work around, had to duplicate data into a new table. When this table graphed, looks as it should. Data from the new table and the new slice are the same. Doesn’t seem like a great permanent fix. Are there better solutions?
Thanks!
Are you using a Column series Chart? If so, it uses the Label column as the X axis label for the chart. This will also be used in any derive Slices.
That explains it… The sheet has a ton or row series data, with a date field for each entry. On the far right of that sheet, created a section which summarizes data based on year. Then created a slice for the summary section. Wondered why the X-axis and some of the data points had specific dates, instead of the year shown in the summary data; makes sense now.
Putting the summary information in a new sheet fixes the problem, as the label for the existing sheet needs full dates. Trying to mix apples/oranges no worky. 
Thanks for the explanation.
1 Like