Hi - I'm trying to use a pivot table to analyze budget data that is spread out over a 12-month period. The problem is that when I drag the data for each month from the field list into the data field on the Pivot Table layout, the data is shown in only one column vertically. I need to have the data shown in multiple columns going horizontally across -- Oct - Nov - Dec etc. and not
Can anyone help me to change the configuration of the layout so that the data is presented horizontally instead of vertically? Any help would be much appreciated.
By rearranging data, the Pivot works well. Not sure how you receive the data, but this approach requires adding a Month column and then all data is vertical. I also added a dynamic named range, so you can add each month's data below, and the Pivot Table will automatically include (after refresh Pivot button is clicked).
Last edited by shades; 02-11-08 at 15:21.
old, slow, and confused
but at least I'm inconsistent!
HI Schades - Thanks much for your effort. I hadn't thought of putting the monthly data in that fashion, but it works. It will just mean a little more effort to reconfigure the raw data. What is puzzling to me is that the sample pivot table that EXCEL puts out (see attached) shows that quarterly data can be configured in a pivot table to display horizontally and not vertically. It would seem to me that I should be able to configure my monthly data the same way (i.e. by just dragging and dropping each monthly field into the data layout on the pivot table. However, when I try it with my data, I don't get the same result as when I do it with the quarterly data on the sample. And I don't know why. If you can figure it out, please let me know. I hope you're not putting in any extensive effort into the other option of creating formulas. I had no intention of creating work for someone else. However, if you do come up with another alternative, I would very appreciative in seeing it. Thanks, again for you help.