+ Reply to Thread
Results 1 to 3 of 3

URGENT pls help me with this overlaping bar chart

Hybrid View

spartacus13 URGENT pls help me with this... 03-31-2013, 01:26 PM
AndyLitch Re: URGENT pls help me with... 03-31-2013, 01:43 PM
spartacus13 Re: URGENT pls help me with... 03-31-2013, 03:21 PM
  1. #1
    Registered User
    Join Date
    03-31-2013
    Location
    Chittagong, Bangladesh
    MS-Off Ver
    Excel 2010
    Posts
    4

    Unhappy URGENT pls help me with this overlaping bar chart

    i have got stuck in making this chart. i am uploading a chart that i want to create. pls help to create this bar chart. its urgentdata.JPG

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: URGENT pls help me with this overlaping bar chart

    1. Create a basic 2D bar chart using the data
    2. Click on the first series bar and then right click.. and select "Format Data Series"
    3. In the Series options, set overlapped to 100% and select OK
    4. Select the 2nd data series --> right click and select "Format Data Series"
    5. Set Series Options - Overlapped to 100%
    6. Set Gap Width to 200% or thereabouts
    7. And select Radio Button - Plot series on secondary axis.

    Adjust all the above for desired effect
    Elegant Simplicity............. Not Always

  3. #3
    Registered User
    Join Date
    03-31-2013
    Location
    Chittagong, Bangladesh
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: URGENT pls help me with this overlaping bar chart

    Thank you so much. it worked.

+ Reply to Thread

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