Improve company productivity with a Business Account.Sign Up

x
?
Solved

Line Chart Needed

Posted on 2011-09-23
2
Medium Priority
?
190 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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

595 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