ExcelTip.com
Account Icon Account Icon Account Icon
ExcelTip.com

Go Back   Excel Help Forum > Microsoft Office Application Help - Excel Help forum > Excel Programming > Excel Charting

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 05-26-2005, 06:15 PM
Mark
Guest
 
Posts: n/a
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
Reply With Quote
  #2  
Old 05-26-2005, 06:15 PM
Barb R.
Guest
 
Posts: n/a
RE: Column Chart labels on all columns

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 With Quote
Reply

Bookmarks

New topics in Excel Charting


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


All times are GMT -4. The time now is 09:05 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0