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...

dan_l, I have a database of stock transactions where one column (field) is labeled "Action" and another is labeled "Shares". Action can have have one of three entries: buy, sell, or dividend. And the shares field is the number of shares and it's always a positive number. What I want is to...

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...

Every cell to the right of and below C16 has protection switched off. So when sheet protection is turned on it is to protect those other cells, I can't import data. How do I import data and still protect the content of those other cells? Lawrence

Thanks kanti. But how do I create the macro so that the user can have access to Data > Import external data and NOT be able to say delete the button that triggers the macro? Or delete hidden formulas? Right now, I have three parts to the dashboard: the database sheet; a pivot table...

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...

Hui, I really like your ideas. Currently, the main chart is VERY dynamic (scroll across time periods, select which data series to show) and I would like to add a feature where the user can click on a column and get it the chart to show detail of that column. For example, click on the exports...

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...