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

d bar charts

ResolvedVersion 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:

Find cells that match a format

In Excel you may wish to find cells that contain a specific formatting such s colour.

Select Edit > Find, click on Options and then Format...choose the formatting that you want found and click on OK

Choose one of the Find buttons to find.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.