Scatter Chart – Multiple Series

Topic

New Reply

Fairly Simple Question

Had a request to create a scatter graph. The data series is to plot the due dates of each task. The due date is the X axis, Task is the Y axis.

Data Series is as follows:

Task 1 – Due 3/19/2010
Task 2 – Due 5/1/2010
Task 3 – Due 7/15/2010
Task 4 – Due 12/15/2010

The graph should show Tasks 1 through 4 as individual items on the Y axis with a plotted point shown for the corresponding date on the X axis. Something similar to the look of the attached sheet.

Sounds easy enough but I can’t do it. I could create something similar using a pivot table but they want a graph. Can someone please steer me in the proper direction.

Reply | Quote

Replies

This is as close as I can get with a scatter chart. A line chart (with axes reversed) would be easier! Or even a bar chat with no fill and data labels set to display X.

Reply | Quote

This is as close as I can get with a scatter chart. A line chart (with axes reversed) would be easier! Or even a bar chat with no fill and data labels set to display X.

Rory,
Thanks. The example helped a lot. However, I do have one question.

How did you get the starting date of the X Axis to lock to the date? Whenever I set the min and max values for the X axis the min always resets back to zero and shows on the graph as 1/0/1900. (I do not want it to do this!) Thanks.

Reply | Quote

The dummy series (for the labels) are all plotted on a second X axis (formatted with no line or labels). I didn’t adjust the primary X axis at all. Does that help?

Reply | Quote