Pivot table charting formats

[nparsons75]

Hi,

I have a table that I have created pivots for and need to now create a chart from the pivot. I am having an issue due to the way my table is formatted, hopefully someone can help.

Ok, my original table is laid out in this way.

jan

jan

feb

feb

mar

mar

apr

apr

may

may

jun

jun

jul

jul

aug

aug

sep

sep

oct

oct

nov

nov

dec

dec

bud

act

bud

act

bud

act

bud

act

bud

act

bud

act

bud

act

bud

act

bud

act

bud

act

bud

act

bud

act

5

4

67

55

4

3

40

32

50

14

27

33

34

36

15

19

25

25

29

36

24

35

42

32

<tbody>
</tbody>

Where the months are shown above, in the original file where two months are shown, there are merged cells, therefore jan is merged across the top of bud act and centred. This is the same for all months.

When I am procing the chart, I need the months to be grouped if thats the correct wording...

Currently each column is separated through the chart, jan jan feb feb mar mar for example.

I need to see Budget vs Actual for each month, so the gap width between Jan and Jan will be minimal (for example 50%) and the gap width between months would be greater. An example below (not the greatest but couldnt think of a better way to demonstrate)

Jan Jan Feb Feb Mar Mar Apr Apr etc......


Hope that makes some kind of sense...

Thank you in advance for any support

 

[pbornemeier]

If you arrange your data like this:

jan 5 4
feb 67 55
mar 4 3
apr 40 32
may 50 14
jun 27 33
jul 34 36
aug 15 19
sep 25 25
oct 29 36
nov 24 35
dec 42 32

You can get the chart you want with a Clustered Column chart.

I don't know of a way to get the chart you want with your current data layout.