pivoting chart hell

hostelowner

Board Regular
Joined
Apr 19, 2005
Messages
105
hello,
does anybody know how to put the following into a pivot table and graph.
need to see
y-axis 0- 90000 (net sales $)
x-axis different weeks
the graph should show a dot line graph for one store at each week.

any help..THANK YOU
MR. Sheet

below is the chart
graph 1.xls
ABCDE
1ENTIRE COMPANYMay 30 - Jun 05Jun 06 - Jun 12Jun 13 - Jun 19Jun 20 - Jun 26
2TRAPEZA, DC$ 61,770$ 48,500$ 59,241$ 56,765
3LENOX, GA$ 20,073$ 23,053$ 23,406$ 21,140
4BEVA - FAIR OAKS, VA$ 17,754$ 15,337$ 12,228$ 17,358
5UCB PALM BEACH, FL$ 14,902$ 14,768$ 18,424$ 24,641
6UCB SOUTH BEACH, FL$ 27,915$ 22,168$ 30,751$ 32,057
7GARDEN, NJ$ 19,062$ 15,923$ 13,601$ 13,052
8
Sheet1
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
Why do you need to put it INTO a pivot table, it looks like it came out of one.

To make a chart, select the data range and start the chart wizard. In step 1, choose a line chart. In step 2, select Series in Rows. In the rest of the steps, apply whatever formats and options you need.
 
Upvote 0
the whole story

Hello,

I would like to have an interactive graph from this data, and I was told to create a pivot table with the table you see, this will make my graph more interactive.
(ie: select single store to show plots, whole districts, etc. I originally intended to use a drop down box created in the add MS excel 5.0 dialog in the same workbook, but I was told this would do the trick)

So I used the wizard and started creating my pivot table, with the intention of having an interactive chart/graph. The source table (what you see posted) is basically single columns from multiple weekly sales reports cut and pasted onto one sheet. (as per the dates on the chart) Originally I created a graph showing this data, but 100 store locations all plotted on the same xy axis made it a little hard to see, so I figured it was necessary to be able to select either by district or a single store.

Anyway, the part I actually got stuck on was with the wizard. Try to do this yourself with the chart I provided, and if you manage to get it, then it should work with the whole chart and therefore solve my problem (very great full). 

PIVOT TABLE AND PIVOT CHART WIZARD
Step 1 use current list or database/ pivot chart with pivot table report
Step 2 select cells to be included as data….
Step 3 of 3 shows an option “layout…”

It is step 3 that I get stuck on because upon selecting this I attempted to make my graph show
X axis = each week
Y axis = total $ cost.
The graph should show the plotted detail.

I can’t seem to get the wizard to layout my graph like the first one I did.


Help…

Hope this is not all to confusing.

Thank you
 
Upvote 0
I found a solution to my problem... must have been the second cup of coffee tht did it.

rows = all stores
data source includes all the weeks

series are rows not columns.
-----------------------------------------

Thank you
 
Upvote 0

Forum statistics

Threads
1,223,483
Messages
6,172,532
Members
452,463
Latest member
Debz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top