ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Newbie...need more space between entries on X axis (https://www.excelbanter.com/charts-charting-excel/51669-newbie-need-more-space-between-entries-x-axis.html)

SRS

Newbie...need more space between entries on X axis
 
I know this should be simple...just can't find it.

I have a basic bar chart with four values for each of our ten clients. The
client names are on the X axis running horizontally and their sales, etc. are
on the Y axis.

I simply want to put more space between each client so that the values of
client #1 don't run up against the values of client #2.

Does this make sense? I'm using Excel 2003.

Thank you!

Debra Dalgleish

Newbie...need more space between entries on X axis
 
Click on one of the bars, to select it
Choose Format Selected Data Series
On the Options tab, increase the Gap Width setting
Click OK

SRS wrote:
I know this should be simple...just can't find it.

I have a basic bar chart with four values for each of our ten clients. The
client names are on the X axis running horizontally and their sales, etc. are
on the Y axis.

I simply want to put more space between each client so that the values of
client #1 don't run up against the values of client #2.

Does this make sense? I'm using Excel 2003.

Thank you!



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 02:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com