[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 188
  • Last Modified:

Line Chart Needed

I need a straight line chart that represents the times for the attached data along the bottom.  I've tried lots of stuff but nothing is giving me the output needed.  Assistance is greatly appreciated.
Line-Chart-Needed.xlsx
0
rtod2
Asked:
rtod2
1 Solution
 
Patrick MatthewsCommented:
Your data series is entered as text, not as numbers.

1) I did a find/replace to look for:

<space>g<period>

and replace it with nothing.  That recast the entries as numbers.  I then applied this custom number format:

0.0" g"

2) I then was able to create a line chart in the usual manner
0
 
rtod2Author Commented:
Outstanding answer!  Charts never did seem to come out right and now I know why.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now