How do I change a bar graph from vertical to horizontal in Excel? Click on the data series that you want to plot on a different axis. The Chart Design tab is now displayed along with the Format tab.