Line Chart

[TheRins3r]

Im looking to have a line chart that shows a % for the number of sku's that were delivered on time.

At present everything shows at 100% ( which is wrong, as some sku's were delivered outside of their 2 day SLA ).

Im not great with charts , so could do with your help.

Axis: Chart Date
Values: Count of % on time

 

[Jon Peltier]

What's the chart type? Line chart? Stacked 100% line chart? If it's the latter and you only have one series, it will only show 100% no matter what values are used.

Maybe it's not the chart, but the data. Where does the data come from? Did you convert it properly to a percentage?

 

[TheRins3r]

Its a line chart & shows everything at 100%.

Im pulling the data from an excel file.
I havent worked out the percentages ( was hoping the line chart would do that for me ), I only know what is "On time" and what is not "SLA missed".

 

[Jon Peltier]

For the most part, a chart can only plot the data you select. If you want to show a percentage, then calculate it in the worksheet, and plot the calculated data.

 

[TheRins3r]

This approach worked , thanks!