How-to Stop Excel Charts from Overlapping Second Axis Columns or Bars ON A PIVOTCHART

Much of a pivot chart is fixed by the pivot table, which is determined by the raw data. I think you would simply need to apply the same concept to the raw data. Add empty "pad tea" and "pad coffee" type columns to your raw data table, include those empty columns in your pivot table report, and they should then be available to your pivot chart to keep the coffee and tea columns from overlapping.

If you don't like that alternative, I suspect you could also create a regular, non-pivot, chart so you can include the data from within the pivot table and the "pad -" data from outside of the pivot table in the same chart. If I have not already pointed you to it, Jon Peltier has a good discussion about the limitations of pivot charts and how to create regular charts that use pivot table data: http://peltiertech.com/regular-chart...-pivot-tables/