stacked column- value axis not displaying correct values

D

DVanBruggen

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I have created a basic chart showing sales numbers vs. plan for January, February and YTD. The original chart was created as a clustered column chart, but I would like to make it a stacked column so sales and plan are displayed in one column for each month. When doing this the vertical value axis scale adds plan and sales together and makes it appear that sales are higher than they actually are. I need help figuring out how to change the vertical value axis so it displays a value near the actual sales number.

example of data:

Jan Feb YTD
Plan $50 $50 $100
Sales $60 $60 $120

Thanks!
DVB
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clusted stacked column chart - "Value (Y) axis crosses betweencategories" greyed out problem 0
Defining x-axis values NOT labels in column charts ExCel 2008 1
Stacked column chart in duplicate 1
Display percent and value on stacked column chart 0
Excel 2007 charts: want to avoid zero values 1
How do I create a combined 'cluster' and 'stacked' column chart? 1
Stacked column chart narrow bars wanted 5
Data labels along below x axis when y axis has negative values 1

Top