Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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: http://www.keithtwombley.com/speedochart.png

chart

share|improve this question

1 Answer 1

up vote 1 down vote accepted

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 enter image description here

share|improve this answer
    
Are you adding a text box behind the chart, to make it look cropped? Setting the fills to No Fill won't allow me to resize the chart without scaling. –  Keith Twombley Mar 14 '12 at 16:37
    
Yes, sorry yo not be clearer. That is exactly what was done. it is not actually cropping the chart, just making the background of it, and the one section transparent, and then wrapping it all in a textbox behind. The 'Financial Health' was textbox as well. Not what you asked for in terms of cropping, but what might work –  datatoo Mar 14 '12 at 16:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.