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
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 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | ENTIRE COMPANY | May 30 - Jun 05 | Jun 06 - Jun 12 | Jun 13 - Jun 19 | Jun 20 - Jun 26 | ||
2 | TRAPEZA, DC | $ 61,770 | $ 48,500 | $ 59,241 | $ 56,765 | ||
3 | LENOX, GA | $ 20,073 | $ 23,053 | $ 23,406 | $ 21,140 | ||
4 | BEVA - FAIR OAKS, VA | $ 17,754 | $ 15,337 | $ 12,228 | $ 17,358 | ||
5 | UCB PALM BEACH, FL | $ 14,902 | $ 14,768 | $ 18,424 | $ 24,641 | ||
6 | UCB SOUTH BEACH, FL | $ 27,915 | $ 22,168 | $ 30,751 | $ 32,057 | ||
7 | GARDEN, NJ | $ 19,062 | $ 15,923 | $ 13,601 | $ 13,052 | ||
8 | |||||||
Sheet1 |