help please excel pie charts

  frior-one 12:25 17 Feb 04
Locked

i have a small table of 5 rows and 6 columns.
each line is sales data for a saleman over 6 months.
how do i program the pie chart to make it possible for me to change the salesman i want pictured without going into the chart and changing the source data. i have been trying the =indirect and =address lookups with out success. any pointers please....

  pc moron 14:45 17 Feb 04

I'm assuming your data is arranged as follows:

Column A has a header called "Name" and the name of each salesman in it.

Columns B to G have a month header e.g. Jan, Feb etc.

The rest of the data is a sale amount for each salesman.

Select the data and from the menu bar select Data then Pivot Table and Pivot Chart Report.

Follow the wizard through making sure you select Pivot Chart Report (with Pivot Table Report) in the first step.

From the chart type select Pie Chart.

Drag the "Name" item to Drop Page Fields Here and drag each month to Drop Data Items Here.

If you select a name from the drop down list, the chart will update automatically.

  frior-one 14:51 17 Feb 04

thanks for that, i have not done much with pivot tables so forgive me if i take a while to report back success.
regards

This thread is now locked and can not be replied to.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

1995-2015: How technology has changed the world in 20 years

Hands-on with the Star Wars fighting drones you can fly yourself

15 macOS Sierra tips | How to use macOS Sierra: Secret tricks and best new features in Apple's new…