+ Reply to Thread
Results 1 to 3 of 3

Need to make the attached chart in excel but struggling!

  1. 05-30-2013, 02:17 PM #1
    abhiindia123
    abhiindia123 is offline
    Registered User
    Join Date
    05-30-2013
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    20

    Need to make the attached chart in excel but struggling!

    Hi! Please see the attached chart. Trying to make the same using excel for an office presentation for the past couple of hours but getting no where! Help please!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-31-2013, 06:37 AM #2
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Need to make the attached chart in excel but struggling!

    You need to use a xy-scatter in order to plot vertical lines.

    For the textual vertical axis you can use a dummy series with data labels.
    http://peltiertech.com/Excel/Charts/ArbitraryAxis.html
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  3. 05-31-2013, 07:52 AM #3
    abhiindia123
    abhiindia123 is offline
    Registered User
    Join Date
    05-30-2013
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    20

    Re: Need to make the attached chart in excel but struggling!

    Thanks! Was unaware of the concept of the dummy series for the vertical axis.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1