Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
Impedding/Overlaying Charts | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |