Link to home
Start Free TrialLog in
Avatar of tim freese
tim freeseFlag for United States of America

asked on

Excel Chart Help

i have three columns:  year, customer name, amount billed

i have 10 rows for each of the past three years for a total of 30 rows.

i need help presenting this in a line chart - i want a line indicating the activity of each customer for each year.

the x-axis should be the year, the y-axis is amount billed, and the line itself should be the customer name.

i am not an Excel person at all - enough to be dangerous and i can't get the graph that i have pictured in my mind... can someone please help me?

i have excel 2007.

thanks.
Avatar of StephenJR
StephenJR
Flag of United Kingdom of Great Britain and Northern Ireland image

Could you post a workbook please?
Avatar of tim freese

ASKER

sure will... thanks.


chartingSample.xlsx
If I were you, I'd use a pivot table to turn your data into a table, with years as columns and customers as rows. Then a line chart should follow.  Does that make any sense?
ASKER CERTIFIED SOLUTION
Avatar of StephenJR
StephenJR
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
i love it... thank you for the help and quick response.