[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Chart displaying in the legend the different product names

Posted on 2011-10-04
8
Medium Priority
?
188 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:easycapital
  • 4
  • 4
8 Comments
 
LVL 50
ID: 36908868
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
 

Author Comment

by:easycapital
ID: 36912155
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
 

Author Comment

by:easycapital
ID: 36917699
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 50
ID: 36920128
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
 
LVL 50
ID: 36920160
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
 

Author Comment

by:easycapital
ID: 36926956
Aha.  I must see what I am doing, because I not getting the wizard above.  Will check once in the office tomorrow.  thanks.
0
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 36928691
That wizard will show when you create a pivot table in Excel 2003 and earlier.
0
 

Author Closing Comment

by:easycapital
ID: 36934863
Hi Teylyn,
Thanks again!
JP
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

872 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