+ Reply to Thread
Results 1 to 3 of 3

Create a secondary not shared axis only for a specific bar

  1. #1
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    842

    Create a secondary not shared axis only for a specific bar

    Dear Experts,

    Please find here attached Sample workbook, Is it possible to create a separate or secondary axis in the right side of the chart but the secondary axis would be specifically for the last bar C.

    If possible request to you kindly do help me out.

    Many thanks and kind regards,

    Neilesh

    Sample Workbook_3.xlsb
    Last edited by Neilesh Kumar; 02-08-2018 at 01:26 PM. Reason: Completing the info

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Create a secondary not shared axis only for a specific bar

    Yes, but you would need to move bar C into a new column that would be a new series in the chart, and then move that second series onto the Secondary Axis.
    Attached Files Attached Files
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Forum Contributor Neilesh Kumar's Avatar
    Join Date
    05-26-2016
    Location
    INDIA
    MS-Off Ver
    2013 & 2016
    Posts
    842

    Re: Create a secondary not shared axis only for a specific bar

    Thank you so much Dear Expert ben_hensel. Thanks a ton Dear Expert.

+ 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. [SOLVED] create secondary axis that makes sense
    By ammartino44 in forum Excel General
    Replies: 7
    Last Post: 04-08-2015, 01:18 PM
  2. Replies: 1
    Last Post: 04-01-2015, 08:10 AM
  3. Excel 2007 : Secondary axis, create grand total bar
    By tecolote12 in forum Excel General
    Replies: 1
    Last Post: 10-17-2011, 04:49 PM
  4. How do I create a stock chart which has two Y-axes and one shared X-axis?
    By Joe Miller in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-12-2009, 06:49 AM
  5. Excel 2007 : How to create a chart secondary axis in XL 2007
    By paulobrien29 in forum Excel General
    Replies: 1
    Last Post: 08-05-2009, 02:36 AM
  6. How to create a secondary y axis with limited data?
    By Newperson in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-08-2006, 09:20 AM
  7. create bar graph with two series and secondary y axis
    By macmullet in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-04-2006, 10:10 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