pivot design

Hello MrExcel World, I'm trying to solve a problem that has peeved me for years. I have searched everywhere for a solution with no luck. What I am trying to do is create a pivot table that bands column values when I have multiple fields as Columns. (See the image below) Right now It works...

I have one question which is bother me for quite some time. Is It possible to make this kind of a chart with pivot chart where the blue columns are the total sales received in one hour interval for example between 13:00 and 14:00 and so on, and then the red line to show me how the orders ware...

Hi In my data, I have: 1. Age (up to 20, 21-30, 31-40) 2. Gender (male, female) 3. Location (London, Paris, Berlin) I want to see Age and Gender as column labels and Location as row labels. However, I don't want Gender as a sub-set of Age - I want Age Labels followed immediately by Gender...

Hi I currently have a data set which looks like this: <table border="0" cellpadding="0" cellspacing="0" width="668"><colgroup><col style="mso-width-source:userset;mso-width-alt:1389;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:3510; width:72pt" span="4"...

Hi, I have a PivotTable with a filter on it. When the user selects an option from the filter, the PivotTable will change in size, from a minimum of about 4 rows, to a possible 40 rows. I have a table directly below it which uses 'getpivot' formulas to perform a few simple calculations. I...

Hi, I've got a projections calculation and I'm wondering if excel has an easy way to do this...the data goes like this: <TABLE style="WIDTH: 409pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=545 border=0><COLGROUP><COL style="WIDTH: 74pt; mso-width-source: userset...