Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mark
 
Posts: n/a
Default Column Chart labels on all columns

I have a column chart that shows info about a set of items (in this case,
projects), which are grouped into categories (business units). I can gen 3
charts for the set of projects, showing data of interest about the projects
(staffing, capital cost, expected ROI). Since the projects are grouped by
BU, a project 's column has the color associated with its BU.

So far so good.

The trouble is, on the X axis, I only seem to get every other Column labeled
(in this case, with the name of the project). It would be Very Helpful to be
able to see *all* of the columns labelled with their project names.

Any suggestions?

Thanks in advance,
Mark
  #2   Report Post  
Barb R.
 
Posts: n/a
Default

Change the X axis scale so that the number of categories between tick mark
labels is 1. You may need to change to font size of the labels so that you
can see them and possibly rotate them a bit.

"Mark" wrote:

I have a column chart that shows info about a set of items (in this case,
projects), which are grouped into categories (business units). I can gen 3
charts for the set of projects, showing data of interest about the projects
(staffing, capital cost, expected ROI). Since the projects are grouped by
BU, a project 's column has the color associated with its BU.

So far so good.

The trouble is, on the X axis, I only seem to get every other Column labeled
(in this case, with the name of the project). It would be Very Helpful to be
able to see *all* of the columns labelled with their project names.

Any suggestions?

Thanks in advance,
Mark

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column Chart Hans Knudsen Charts and Charting in Excel 1 May 6th 05 01:35 PM
Column Chart Hans Knudsen Charts and Charting in Excel 1 May 6th 05 06:49 AM
Stacked column and column combo chart KG Charts and Charting in Excel 5 March 16th 05 02:01 PM
Bar chart & Category (x) axis labels Airi A. Charts and Charting in Excel 0 March 15th 05 03:09 PM
Auto Skipping and protected cells Dave Peterson Excel Discussion (Misc queries) 6 January 27th 05 11:35 PM


All times are GMT +1. The time now is 05:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"