Results 1 to 5 of 5

Thread: Line Chart
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2016
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Line Chart

    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

  2. #2
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,678
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Line Chart

    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?
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

  3. #3
    New Member
    Join Date
    Dec 2016
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Line Chart

    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".

  4. #4
    MrExcel MVP
    Join Date
    May 2003
    Location
    USA
    Posts
    4,678
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Line Chart

    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.
    Jon Peltier
    Peltier Technical Services, Inc.
    Try Peltier Tech Charts for Excel

  5. #5
    New Member
    Join Date
    Dec 2016
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Line Chart

    This approach worked , thanks!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •