Trouble setting total for on chart
I am trying to get 50 to be the highest number, and I want to show my data
reaching towards 50. How do I do this with the bar chart? Thanks. |
Mark,
Double-click on your Y value axis. In the Format Axis dialog box, go to Scale. Set the maximum to 50. You can choose other options as you like (for example minimum = 0, major unit = 10, minor unit = 2, etc.) If you just want to show one column moving toward a goal, type the number 50 in a cell. With your curser in that cell, go to the Chart Wizard and choose a Clustered Column chart with the Series in rows. Then, double-click on your Y value axis and in the Format Axis dialog box, go to Scale. Set the maximum to 50, the minimum to 0, and the major unit to 5. Finally, to have the chart show 60% of your goal, replace the number 50 with 30. ---- Regards, John Mansfield http://www.pdbook.com "Mark" wrote: I am trying to get 50 to be the highest number, and I want to show my data reaching towards 50. How do I do this with the bar chart? Thanks. |
All times are GMT +1. The time now is 01:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com