Chart displaying in the legend the different product names

Looking to have the graph
- display on the y axis the Gross Margin
- on the "X" axis the product corresponding for the value above
- have all products show per month
- legend to show the color for each product
- line chart type.

Thanks,
JP
aaa.bmp
Chart-legend-showing-products.xls
easycapitalAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello JP,

I'm not sure what you mean by

"on the "X" axis the product corresponding for the value above" in conjunction with "have all products show per month"

If the X axis shows the products, and you want a line chart, how/where do the months come in? Can you draw that on paper? A line chart is typically used to show a trend over time. So the X axis would be a time axis.

Attached is a pivot chart that summarizes the data, shows dates on the X axis and lines for each product.

Not the best chart to portray the data, in my humble opinion. Are you open for better options?

cheers, teylyn


Chart-legend-showing-products.xls
0
easycapitalAuthor Commented:
Hello Teylyn,
Thanks for the resulting graph. It displays what I was aiming for.
I will be able to open the attachment when I get into the office tomorrow.
Good night.
Jp
0
easycapitalAuthor Commented:
Hi Teylyn,

When I try to create a pivot chart, it occupies an entire sheet.
How did you get it to appear with the same page of the pivot table?

Thanks,
JP
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
In the dialog to create a Pivot chart, click "Existing Worksheet" and select a cell in a Worksheet. That will then be the top left corner of the pivot table that feeds the chart.

cheers, teylyn
6-10-2011-8-39-10-a.m..png
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
The screenshot above is Excel 2010, in 2003 the setting is in step 3 of the wizard
 shot
If you don't want to do the chart all over again, you can move an existing pivot chart to a regular worksheet:

In 2003:
- select the chart
- click Chart menu > Chart Location > As object in > select sheet > OK
0
easycapitalAuthor Commented:
Aha.  I must see what I am doing, because I not getting the wizard above.  Will check once in the office tomorrow.  thanks.
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
That wizard will show when you create a pivot table in Excel 2003 and earlier.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
easycapitalAuthor Commented:
Hi Teylyn,
Thanks again!
JP
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

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.