Search results

Hi, Is it possible to to concatenate two field names into one and place the new field in the row area of a pivot table? Here's the deal: Every week, sales data is dumped into a spreadsheet that we then use to create a pivot table. It's sales by country, and each country has a region...

Hi, Is it possible to use a function containing text in a calculated field of a pivot table? I've tried several different functions, but text always generates zero values. For example, can I create =IF(ACTION="Sell",SHARES,0) which would sum the field SHARES if the the corresponding field...

Hi, Is there any work-around for importing external data into a protected worksheet? I have a worksheet that the user can use either to copy-paste a database or to use Excel's 'import external data' on the data menu. That database worksheet then feeds a dashboard. Problem is that there are...

Hi, Is it possible to group X-Axis labels into labeled categories? I have a clustered column chart where the y-axis is revenues and the x-axis are the different company products. Each product is composed of 6 columns which are the trailing 6 months of revenues. What I would like to do is...

Hi, I have a chart design dilemma I could use your wisdom on regarding the maximum number of series to throw on a chart. I designed a dashboard for a client where the main (largest) chart is a clustered column showing sales over six months. There are 3 - 4 columns in each cluster, each...