View Single Post
  #1   Report Post  
BuriedInSpreadSheets
 
Posts: n/a
Default sort bar chart in excel

Every day I update a spreadsheet for our daily sales figures. Associated to
that spreadsheet are several different charts including some bar charts. Is
there a way to auto-sort bars within a bar chart from the lowest number to
the highest or vice-versa without having to manually change the order of the
data series?