##
15 posts tagged with pivot.

Displaying 1 through 15 of 15. Subscribe:

## Is it possible to do a Gantt chart with a 3rd (or more) dimension?

I'm working on project planning a multi-year, multi-department initiative. Each department will complete identical tasks but on staggered schedules. I'm hoping to find a way where I can create a single dataset that will then display task schedules across department, and department schedules across tasks. I am using microsoft project and microsoft excel. content sample inside [more inside]

## Pivot table help for n00b

I need to provide some sales data but am unsure how to manipulate the data in a pivot table to get the specific details requested. I'm sure this is simple but my pivot table skills are, admittedly, terrible. Details inside. [more inside]

## Time to get a new job pt. 2

I know exactly what I want out of work, and it is this: working on creative projects to make something useful (and also cool) as part of a team. And also money. Not tons, but enough to get by. I have a BA, but nearly all my work experience to date has been in low/no-skill labor. How do I bootstrap myself into a new career and what should I even be looking at? [more inside]

## Help me pivot the pivot table back!

How to reformat pivot table data so that it works like any other spreadsheet? Simple instructions needed. [more inside]

## How can I reformat some rows into columns in Excel?

How can I reformat some rows into columns in Excel? [more inside]

## Microsoft Acess Charts dead-end.

Microsoft Access 2007 - how on earth do I cut / copy / export / do

*anything*with my Pivot Chart, besides print it? [more inside]## Differences between Excel Pivot Tables

Why is the functionality of an Excel Pivot table different depending on whether you use a list or a multiple consolidation range? [more inside]

## This might be someone's homework, but it's not my homework

I'm trying to teach myself to be an Excel guru, and I'm having trouble with pivot tables. I'm using data from exercises in a textbook (which is about how information systems are used in business but randomly has a bunch of Excel exercises in the back). I can come up with a solution, but I don't know if I'm doing it the most efficient (or most elegant) way. [more inside]

## Excel, Pivot, Dates.

Excel - Pivoting With Dates [more inside]

## Help me figure out how to go about making Excel magic

How can I have Excel generate a new column with the data I need using certain conditions and pulling data from a pivot table? [more inside]

## Can I make an Excel chart from only one column?

How can I create a chart in Excel 2007 showing the number of times a certain value occurs in a column? [more inside]

## Stumped by VBA-ising an array formula in Excel

How to do a VBA version of the following array formula in Excel?
The following array formula (entered with ctrl,shift,enter) will produce the string 'Bank statement'!H842, which is the name of a cell I would like to be able to manipulate via VBA:
{="'Bank statement'!H"&MATCH(C1&D$39,'Bank statement'!A:A&'Bank statement'!C:C,0)}
[more inside]

## Please Help Me Create Stick Figure Servants To Do My Bidding

I'm lusting after Pivot Stickfigure Animator 2.2. The problem is, I have a Mac and it's for Windows. [more inside]

## Excel - Concatenate fields through Vlookup...or something

Excel Filter: Concatenating fields through VLOOKUP. Is it possible? What I'm trying to accomplish inside... [more inside]

## Pivot Table Charting Help

Help me with creating two bar charts from two columns in one pivot table, please? [more inside]

Page:
1