The Clustered Bar will ... Click the horizontal (value) axis. On the Format Data Series pane on the right, click the Axis Options button. Set the Maximum target value for your chart in the Maximum ...