?
Solved

Line Chart Needed

Posted on 2011-09-23
2
Medium Priority
?
189 Views
Last Modified: 2012-06-21
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
Comment
Question by:rtod2
2 Comments
 
LVL 93

Accepted Solution

by:
Patrick Matthews earned 2000 total points
ID: 36586949
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
 

Author Closing Comment

by:rtod2
ID: 36588210
Outstanding answer!  Charts never did seem to come out right and now I know why.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

593 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question