I followed some instructions to create a speedometer chart (pie chart with a scatter line chart on top).

However, this solution leaves a large blank space below the chart; 50% of the chart's space is taken up by a blank pie slice to make the chart take up the normal semi-circular speedometer shape.

I have dragged the plot area handles out as far as they go in the chart area, but I can't drag them outside of the chart area to make it bigger.

Attempts to resize the chart area will automatically scale the chart down so it doesn't crop.

Is there a way to crop a chart in excel, so that some of it is simply gone, rather than rendered white and taking up space? Solutions relying on cropping a screenshot are undesirable as a screenshot won't update when the data source changes.

See attached picture for example.

Edit: I can't seem to upload the chart. Here is a link:

1 Answer

Format the bottom Data Point with no fill, and the Chart Area with no fill. Use textboxes to contain the area you like, and provide the title. This sample is not the same graph but shows the idea

2

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy