Changing vertical axis in chart in Excel

N

nobuhle sibusiso

I have created a chart in exel that is supposed to represent monthly sales
throughout the year in various categories. The vertical axis, which i need
to reflect dollar amounts only reflect percentages. The months and the
categories are correct. How can I change that vertical axis to match the
financial data in my worksheet. I have the months in row A, and I have the
categories in column 1. The financial data is in the corresponding cells.
I'm running Office 2OO7.
 
Top