title: PivotChart sort by value
body: <p>How to tell excel to sort pivot chart values by integer value, not alphabetically?</p>
  
  <p>When I use raw time data it sorts correctly:</p>
  
  <p><a href="https://i.stack.imgur.com/ejJUC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ejJUC.png" alt="enter image description here"></a></p>
  
  <p>But when I use the built in aggregation functionality of Pivotchart for displaying hourly data - sorting goes from sort by value to alphabetical sort:</p>
  
  <p><a href="https://i.stack.imgur.com/wXroM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wXroM.png" alt="enter image description here"></a></p>
  
  <p>Hours 7, 8 and 9 go to the right of the chart.</p>
  
  <p>Values on X axis are duration data form cell that is custom formatted like [h]:mm:ss,000.</p>
  
  <p>Only options that I can see are "sort A -> Z" or "Z -> A"</p>