Hello,

I am trying to use a pivot table to create a stacked bar chart of 5 different events, and then look at those by day. I am also trying to have a line graph depicting lunar illumination on each of those days as well (which would require a secondary axis). I know how to do this with normal data, but since pivot tables are somewhat inflexible, I have having trouble creating thi secondary axis.

Thanks for the help.