View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gor_yee Gor_yee is offline
external usenet poster
 
Posts: 38
Default Pivot Charts/Graphs

Hi all, just got a question, I've got a pivot chart that shows the
ratio between promotional sales vs standard. The graph shows the
"Standard" as a column chart type while the "promotional" sales has it
in a line graph...so every time i change it to another trading
department, it just reverts back to the column graph and no line
graph..how do i make it so that it will show a column and a line graph
on every trading department that i choose??Please help...thanks a
million