+ Reply to Thread
Results 1 to 2 of 2

Managing Multi level X axis

  1. #1
    Registered User
    Join Date
    09-13-2013
    Location
    Thane, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Managing Multi level X axis

    Is it possible to change the fonts of the level I did not find any soluton on this. I also have same problem. I use multilevel graph to show progress of tasks. There are indicators Planned Start date, Actual Start date, Planned Finish date, Actual Finish Date, and Golive date. I need to show number of these dates in each calender week e.g. Number of tasks have planned date in calender week 32, No. of tasks have planned date in calenedr week 33, and so on. Similarly for others i.e. Actual Start date, Planned Finish Date, Actual Finish date and Golive date. Hence I opted for Multiple level X axis now when plotted the graph each Calendar week on X axis had 5 ub units. But the colour of all bars was same. Hence I selected one bar (data point) and right clicked for popup menu and selected option Format Data point then I went to Fill option in fill option I selected Solid Fill and Vary colours by point. But this gave the different colours to each graph. What I wanted that all Bars of Planned Start Date should be in Blue All Bars of Actual Start Date in yellow, All Bars of Planned Finish Date should be Cyan colour and Go Live bar in Red colour which I had to do by selecting each data point one by one. Further When I took this graph in Power point by reducing the size X axis was in mess and no one was able to recognise which bar is for which category as I had removed the legends to optimize the space. if I keep the legends then there will be whole list of ligends as it shows five legends per calendar week. Hence I have 20 calendar week then 20 X 5 = 100 legends.

    What I want to do is I want to remove the labels of category from X axis and I want to show 5 legends only.

    Does any one has solution.

  2. #2
    Registered User
    Join Date
    09-13-2013
    Location
    Thane, India
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Managing Multi level X axis

    Further after posting this post I did some work around I wen to series of this Chart by selecting Format tab and selected only Calendar week and removed the types of bars. Since I had already coloured the Bars as per the category of bars they remained as it is. Now the lables of category from X axis has got removed and hence mess in X axis atleast got eliminated. But it has changed the tags of legends also. Earlier legeends was showing Calender week No. and category name of bar which was confusing as "32 Planned Start" . Lay man gets confused what is 32 ?. now only calendar week is shown no category name.

    Need some solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Bill of Materials conversion from multi level to single level
    By susmitpatel in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-11-2013, 12:53 AM
  2. Graph X axis (multi-level category labels) not showing all the text
    By mclhone in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-05-2013, 09:33 PM
  3. formatting a multi-level catagory axis label???
    By nmoore5 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-17-2013, 03:04 AM
  4. Multi level BOM
    By neorez in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2010, 05:22 PM
  5. Using macro to convert single level BOM to Multi Level BOM
    By andrew_chong in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2006, 04:57 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1