Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Excel line chart

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
dbfromnewjersey
Asked:
dbfromnewjersey
1 Solution
 
Rgonzo1971Commented:
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
 
Rory ArchibaldCommented:
It sounds to me as though a pivot chart would work with the original layout but a sample workbook would help.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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