+ Reply to Thread
Results 1 to 2 of 2

How to plot this graph?

  1. #1
    Registered User
    Join Date
    09-03-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    1

    How to plot this graph?

    Hi there,

    I've a beginning of excel but am tasked with creating a graph showing the High, Low, Current and Mean P/E for some stock indexes. I have attached the data gathered but need guidance creating a chart like the jpeg I attached. Please share me the instructions.

    Thanks!
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,820

    Re: How to plot this graph?

    Here's one tutorial for a box and whiskers diagram: http://peltiertech.com/excel-box-and...ams-box-plots/ Let us know what parts of the tutorial you have trouble with.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Line Graph - Do plot zero, Don't plot #NA
    By Janc in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-01-2012, 05:45 PM
  2. How to plot a graph?
    By clumsy.annie in forum Excel General
    Replies: 1
    Last Post: 04-17-2011, 09:38 PM
  3. how to plot a bar graph
    By shayvaknin in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-18-2011, 05:18 PM
  4. how to plot a bar graph
    By shayvaknin in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-18-2011, 05:15 PM
  5. plot x and y graph
    By okl in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-28-2009, 09:49 AM
  6. Graph plot
    By rosh72851 in forum Excel General
    Replies: 1
    Last Post: 11-24-2008, 08:33 PM
  7. How to plot this as a graph?
    By akhlaq768 in forum Excel Charting & Pivots
    Replies: 19
    Last Post: 07-21-2008, 05:56 AM
  8. [SOLVED] how do I create a box-plot (or whisker plot ) graph?
    By raal in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-08-2005, 04:05 PM

Tags for this Thread

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