Show categories with no values in PivotChart

[eschiesser]

Hi all,

I am creating a pivot chart in excel 07 from a table using 4 different columns: Week Number, Acronym, Employee, and Hours. I've got the week number and the employee in the legend, the acronym on the horizontal axis, and Sum of Hours as the values (vertical axis).

The problem is, in the original data table, some employees do not have ANY hours logged under one or more acronyms, and thus there is no entry, producing a null or zero value in the PivotTable, and thus not showing up on the horizontal axis when I make a PivotChart (bar graph).

Is there a way to make those acronyms show on the horizontal axis, even though there is no entry in the original data for that specific employee and acronym combination?

Thanks,

-Eric

Edit: Also filtering so that there is only ONE specific employee per pivotchart