Solved

Excel line chart

Posted on 2013-11-08
2
523 Views
Last Modified: 2013-11-11
I have an Excel file with 3 columns and about 500 rows of data.  Column A contains state abbreviations (AK, AL, CA, NY, etc).  A state abbreviation can appear once, many times or not at all.  Column B  contains dollar values.   Column C contains dates.

I want a line chart that will display the dollar fluctuations over time for each of the states.  How do I set it up?  I haven't used Excel charts much, so I don't know what I'm doing. I tried inserting various versions of line charts but none are resulting in any meaningful data, so I'm obviously setting them up wrong. I need the exact steps.  Thanks.
0
Comment
Question by:dbfromnewjersey
2 Comments
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 300 total points
ID: 39633399
Hi,

For your purpose you have to rearrange your data

the 1st col shoud be date, 2nd col State, 3rd Money than sorted first by date then by State

You can then create a new table with the data sorted: in the first row the different states and in the 1st col the dates and then inserting the rest of the data

Regards
Graph.xlsx
0
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 39633432
It sounds to me as though a pivot chart would work with the original layout but a sample workbook would help.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

762 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now