Multiple Location Timeline

Hi -

It's hard to know what's going on from the picture. You should be able to edit the graph to switch the axes to have dates along the bottom. Would it be possible to post the spreadsheet with your data and graph (removing any sensitive information)? On your reply, select the Go Advanced button, scroll down until you see the Manage Attachments hyperlink, select that and use the buttons to select and upload your file.

Hi -

Attached is your file with the dates along the X Axes. I just edited your chart to set the X Axis data to the dates and the Y axis data to the numbers (1-9) you had immediately to the left. I then also selected the Site name for the Data Label. You right-click in your chart area. Click on "Select Data". Then pick the data set you want to edit (say the first one), and click Edit. From the Edit Series window, pick the ranges for your Series Name, Series X values, and Series Y values.

Take a look and see if this is what you wanted.

Hope this helps.

You're welcome! Thanks for the rep!

Don't forget to mark your thread as SOLVED per the instructions at the bottom of this post.