Fix X axis formatting for graphing histograms
I want to graph data from Histogram function to produce column graphs. Histograms have boundaries for each category. When graphing you can't get the column between the boundary lines on the graph and get the axis labels to line up with the tick marks. If you position axis on tick marks you get the lower boundary label of the category centered on the tick mark which is centered under the column. If you position between tick marks you get the lower boundary label centered under the column and not on the lower boundary. I need to get the column between the tick marks but get the axis labels to line up with the boundaries. My workaround is to position between the tick marks then take the graph into paintbrush and move the labels manually to line up properly with the tick marks at the boundaries of the category. I would like an option in the column graph (and possibly bar graph) to have Excel do this without the workaround. Every time my data changes I have to repeat the workaround manually.
Thanks for the feedback. This is an area we are looking into improving. Please continue to vote on this feature idea.