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
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
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
Thank you so much. it worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks