If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Making Histograms - Data Labels
I want to manually make a histogram. I create a bar chart
and set the gap to zero. The problem I have is with the x- axis data labels. They are aligned with the bars. For a histogram they should be aligned with the tick marks (the divisions between bars) since they indicate boundaries. How do I move the labels?????? |
#2
|
|||
|
|||
Making Histograms - Data Labels
Joe Gruher -
I want to manually make a histogram. I create a bar chart and set the gap to zero. The problem I have is with the x-axis data labels. They are aligned with the bars. For a histogram they should be aligned with the tick marks (the divisions between bars) since they indicate boundaries. How do I move the labels?????? As far as I know, it's not possible. The only workaround I know is to use a combination chart (Column and XY Scatter) where the axis of the XY Scatter chart is used for labeling the axis. It's time consuming, and I don't have step-by-step instructions. - Mike Middleton, www.usfca.edu/~middleton |
#3
|
|||
|
|||
Making Histograms - Data Labels
Go right click on the x axis then click format axis, go to
scale, then make sure "Value (Y) axis crosses between categories" is not checked. -----Original Message----- I want to manually make a histogram. I create a bar chart and set the gap to zero. The problem I have is with the x- axis data labels. They are aligned with the bars. For a histogram they should be aligned with the tick marks (the divisions between bars) since they indicate boundaries. How do I move the labels?????? . |
#4
|
|||
|
|||
Making Histograms - Data Labels
Matt Leonard wrote: Go right click on the x axis then click format axis,
go to scale, then make sure "Value (Y) axis crosses between categories" is not checked. That option puts the tick mark in the center of the bar. I think the original poster wants a standard histogram with both tick marks and numerical axis labels between bars. - Mike Middleton, www.usfca.edu/~middleton -----Original Message----- I want to manually make a histogram. I create a bar chart and set the gap to zero. The problem I have is with the x-axis data labels. They are aligned with the bars. For a histogram they should be aligned with the tick marks (the divisions between bars) since they indicate boundaries. How do I move the labels?????? |
#5
|
|||
|
|||
Making Histograms - Data Labels
Joe can probably find a useful example on this web page:
http://www.geocities.com/jonpeltier/...arts/axes.html - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Michael R Middleton wrote: Joe Gruher - I want to manually make a histogram. I create a bar chart and set the gap to zero. The problem I have is with the x-axis data labels. They are aligned with the bars. For a histogram they should be aligned with the tick marks (the divisions between bars) since they indicate boundaries. How do I move the labels?????? As far as I know, it's not possible. The only workaround I know is to use a combination chart (Column and XY Scatter) where the axis of the XY Scatter chart is used for labeling the axis. It's time consuming, and I don't have step-by-step instructions. - Mike Middleton, www.usfca.edu/~middleton |
Thread Tools | |
Display Modes | |
|
|