I'm trying to create a chart that has the metric going down the side and items like Current Year, Previous Year, and Index to Previous Year along the top. Ideally, each cell would also contain a bar chart consisting of a single, horizontal bar and the value for the given metric for the CY, PY, or Index. I've figured out how to get a pivot table with the metrics along the side, but I don't know how to get CY, PY, and Index across the top since they aren't based on the same field. Also, I don't know if its possible to add bar minichart to a pivot table.
