• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 298
  • Last Modified:

Stuck on a Simple EXCEL Chart

Hi All - I am stuck on how to do a simple Excel Chart. The Attached JPG shows a Screen Shot of what I get when I hightlite the data & click "Marked Line Chart", as well as a hacked-up version of what I am trying to get the chart to look like.
I do lots with Excel, but never Charts.
Can anyone help?
Screen Shot - Want I want vs. What Excel gives me
0
bleggee
Asked:
bleggee
2 Solutions
 
KimputerCommented:
Isn't a PivotChart what you need?

Please note how I changed the Date. Otherwise if you use Dec and Nov, December comes first alphabetically, which you probably don't want.
pivotchart-001.png
0
 
Harry LeeCommented:
Bieggee,

Your problem is the way your data is organized.

Please take a look at the sample file. There are three charts. One with Original data, one with manually rearranged data, and one with Pivot Table and Pivot Chart.
Book1.xlsx
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

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