1

I have a basic Excel sheet having date and time values:

Main Excel Sheet

SLA should be a straight line @ 8:30. The remaining two columns should display the lines for those specific dates. It would look something like this:

Something like this

For now, my image looks something like this:

Currently Looks like this

The spiked ones are the dates which crossed the SLA. Other points are below the entire spreadsheet.

The point is, it doesn't show a timeline for each date. My current chart "Select Data" section is like this image:

Select Data Section

I want lines drawn for each and every date.

  • It looks like you're missing a few images referenced in the post. – Gaff Oct 24 '16 at 20:56
  • SuperUser allows me to add just 2 at a time. – Chetu19 Oct 24 '16 at 21:00
  • Looking for something like this imgur.com/a/x8nOt imgur.com/N5zyhwk – Chetu19 Oct 24 '16 at 21:04
  • I added the images, does that look correct? – Gaff Oct 24 '16 at 21:08
1

If you want to use dates for the X axis, you need to apply a trick when selecting the data for the chart. With a column label for the dates, Excel tries to interpret the column as a series, and that goes horribly wrong.

These are the steps I took to create the chart in the screenshot

  1. Remove the data label above the date column.
  2. Select the data, including the labels, so the top left corner of the selection is the blank cell above the dates, A1 in the screenshot
  3. insert a stacked column chart
  4. select the SLA series in the chart and change the series chart type to line.
  5. format to your liking

enter image description here

By the way, it does not make much sense to stack completion time on top of indicated time. What you really want here is the difference if completion time is later than indicated time.

  • I modified it as per your instructions.. I am unable to view entire data datewise though prntscr.com/cyknc5 – Chetu19 Oct 25 '16 at 4:01
  • Start with a smaller data sample and add data to it until you figure out what's wrong. – teylyn Oct 25 '16 at 9:16
  • Why are some of your time values left-aligned? Looks like text instead of numbers and would explain why they don't plot. The plot seems to be OK for October data. Check your data. – teylyn Oct 25 '16 at 9:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.