Date Graph

Posted on 2011-05-06
Last Modified: 2012-08-14
I have an excel spreadsheet continaing a data range (attached).
I am using Excel 2010.
I would like to create a graph from the data, so that I have a year in months along the bottom, with the specific events plotted on the graph, according to the date.  I have attached a mock up. I dont seem to be able to do a whole year and have the events spanning their dates.  data-range.xlsx graph mockup
Question by:LiamMcKay
    LVL 22

    Accepted Solution

    LVL 31

    Expert Comment

    by:Rob Henson
    Looks like you need what I call a floating bricks graph.

    In simple terms you need to create a stacked graph but there is a series before the individual entries which is "invisible" (white box with white borders on white background). In this case the value of the invisible box would be the number of days from the start of the year to the start of the event. The size of the box is the number of days of the event.

    Rob H

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now