• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 389
  • Last Modified:

Date Graph

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
1 Solution
Nico BontenbalCommented:
Rob HensonIT & Database AssistantCommented:
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now