Results 1 to 3 of 3

Multi Tier Chart Forumla

Threaded View

  1. #1
    Registered User
    Join Date
    08-13-2011
    Location
    Santa Cruz, Cali, US
    MS-Off Ver
    Excel 2007
    Posts
    41

    Multi Tier Chart Forumla

    Hi all,
    I can make a multi tear chart if I set the category axis to cells A3:C6 however I cant if I set it to this:
    ={"FY11","Q3","Jan 2","","","Jan 30",","","Feb 27"}
    Can you please help me find a way I can type that formula so excel understands its multi tier, the reason I need to typed out is because I am creating the chart through vba.

    An image of the problem is below. I want to use formula to acomplish same affect in the above:
    http://img.photobucket.com/albums/v1...u20formula.png
    Thanks!
    Attached Images Attached Images
    Last edited by pg300; 02-14-2012 at 07:49 AM.

Thread Information

Users Browsing this Thread

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

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