d bar charts

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » 3D bar charts

3D bar charts

resolvedResolved · High Priority · Version 2007

Letty has attended:
Excel Advanced course

3D bar charts

I have created a bar chart using a pivot table and would like to make the bars wider however it appears this can not be done is there a way to do this without making the graph wider?

Thanks

Letty

RE: 3D bar charts

Hi Letty

Thank you for your question

If you decrease the gap depth between the bars, this has the effect of widening the bars

Right click on one of the bars and select, FORMAT SERIES. On the
series options pane, move the gap width slider to zero. This will then increase the width of the bars

Hope this is helpful

Regards


Stephen


 

Excel tip:

Switching Between Spreadsheets

As the Alt+Tab key switches between loaded applications or files, Ctrl+Tab switches between loaded or open Excel files. Hold down the Ctrl key until you have tabbed to the correct spreadsheet.

View all Excel hints and tips


Server loaded in 0.09 secs.