I have a bar chart using 6 series of data. I would like 3 to be on one axis, and the other 3 to be on the other. for example, I want to have gross margin dollar amounts on the main axis and ggross margin as a percent on the secondary axis. but when I add the secondary axis all my bars overlap. I have attached data so you can see what i am dealing with. any Ideas on how to fix the problem?
Thanks!
exel question.xlsx
Bookmarks