+ Reply to Thread
Results 1 to 12 of 12

Plot events along horizontal axis

  1. #1
    Registered User
    Join Date
    11-19-2014
    Location
    Knoxville, Tennessee
    MS-Off Ver
    2010
    Posts
    11

    Plot events along horizontal axis

    I have a data set that I have used to compare probability of outcomes. With this I have created charts to display this. However, along the horizontal axis I currently have dates and would like to plot events onto this axis. They are currently displayed in the H column as 'tv, print, radio' but will eventually become more specific. How do I add these events to my horizontal 'timeline'.
    Attached Files Attached Files

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,527

    Re: Plot events along horizontal axis

    Not a real chart expert, but I would say click into the middle of the chart to select it. Right click and choose select data.
    Up at the top where it says chart data range it will look like this.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I would say you just add in the new column, so it looks like this.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I'm assuming this column will eventually be numbers similar to the other two columns. You will see anything until you put some numbers in, but you will see the column header as a legend down in the bottom of the chart.

    Good Luck!!!
    As a reminder, once your original request has been fulfilled please mark this thread as SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

    If you are happy with my help, then please consider clicking the add reputation button in the lower left hand corner of this post.

  3. #3
    Registered User
    Join Date
    11-19-2014
    Location
    Knoxville, Tennessee
    MS-Off Ver
    2010
    Posts
    11

    Re: Plot events along horizontal axis

    Hmmmm. Column H is actually going to be specific events for each date such as 'broadcast of television debate' etc. I want to see if events have an effect on projected probability. So that's why I would like the events to be plotted on the horizontal axis by dates. Preferably the text sitting vertical to the date.

  4. #4
    Registered User
    Join Date
    11-19-2014
    Location
    Knoxville, Tennessee
    MS-Off Ver
    2010
    Posts
    11

    Re: Plot events along horizontal axis

    basically I want the x axis to be a timeline of events.

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

    Re: Plot events along horizontal axis

    I would just add some "dummy" values to a column in to mark the position of the events, then add this column as an additional series. So, put 0 into I2, I4, I7, and so on, then add column I as an additional series. Then format this new series as marker without line. Error bars could be used to make a vertical line across the chart at each event point if desired.

  6. #6
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,833

    Re: Plot events along horizontal axis

    hi jamie2v ,

    Up to my understanding,you require the Event to be displayed along with dates.
    Pleases check the attached sheet is this what you are trying to achieve ? if not please explain me again i will try to understand it again

    Punnam
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    11-19-2014
    Location
    Knoxville, Tennessee
    MS-Off Ver
    2010
    Posts
    11

    Re: Plot events along horizontal axis

    As you can see in the workbook (sheet 1)I have various charts. Right now the x axis on those charts just shows a timeline of dates. I would like this axis to also include events (column H). I could insert markers for my own analysis. But for research presentation I would prefer to have the names of the events on the x axis corresponding to the date the events occurred.

  8. #8
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,833

    Re: Plot events along horizontal axis

    have you checked the first chart upload by me in post 6

  9. #9
    Registered User
    Join Date
    11-19-2014
    Location
    Knoxville, Tennessee
    MS-Off Ver
    2010
    Posts
    11

    Re: Plot events along horizontal axis

    Yes. Unless I am missing something I can't see any difference between that workbook and the one I uploaded. Are you sure you uploaded an updated workbook?

  10. #10
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,833

    Re: Plot events along horizontal axis

    Please Check this file

    Punnam
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    11-19-2014
    Location
    Knoxville, Tennessee
    MS-Off Ver
    2010
    Posts
    11

    Re: Plot events along horizontal axis

    Yes!! Thank you so much!!!

  12. #12
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,833

    Re: Plot events along horizontal axis

    hi jamie2v ,

    Thanks for the feedback & Rep's

    Punnam

+ 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. Replies: 1
    Last Post: 03-01-2014, 07:10 AM
  2. Replies: 2
    Last Post: 11-27-2012, 01:25 PM
  3. Horizontal axis limiting formula in xy scatter plot
    By S K ROY in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-06-2011, 09:15 AM
  4. Replies: 2
    Last Post: 03-11-2011, 09:02 AM
  5. How to plot scatter graph on horizontal axis
    By alsupport in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-28-2010, 04:53 AM

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