![excel for mac 2016 bar chart order excel for mac 2016 bar chart order](https://www.techonthenet.com/excel/columns/images/hide2016_002.png)
Here's the problem: in the setting for Min, Max, Major, Minor, Excel expect 'simple' numbers like 0, 10, 0.5. and have the bars redraw to reflect that scale. You state: I would like to change the X-axis scale and labels to 1:00, 2:00, 3:00, etc. Thanks for any suggestions/solutions you can provide. Is this at all possible or am I asking too much of Excel 2016? Surely, I can't be the first one wanting to do this! I would even go so far as to print an entire year One month from the other just by the colour it is such that if I were to use red and green, for example, and starting with red in January, then I could easily tell that February, April, June, etc. I really don't care about the dates on the bottom-I am perfectly fine with the graph having indiscernible bars for each date as long as I can change each month to an alternating colour so I can tell Scale if February's Hours range was significantly different. It even might even go so far as adjusting the Y-axis Hours to that bar graph would add the dates as numbers to the X-axis and overlap them badly if my chart isn't wide enough horizontally. I tried whole numbers for minimum and maximum (0 and 10) and even 0:00, 10:00, 1:00, and 0:12 (one-fifth of an hour for the minor grid lines) but Excel doesn't accept those-it resets anything I type to decimal values!Ĭomplicating matters, I fear that adding Hours from February, etc. But it seems I can't change in minimum, maximum, major and minor values to reflect this. I would like to change the X-axis scale and labels to 1:00, 2:00, 3:00, etc. The lowest value on that sheet is 1:33, the largest is 9:41. This chart is created with the numbers 1 to 31 as labels on the X-axis and because of the different values for Hours, the Y-axis labels are 0, 1:12,Ģ:24., up to 10:48 as an increment of 1:12. Over a range of time, so in January, I select the 31 values for Hours and create the chart on a 13th sheet. I would like to create a bar graph that displays these values In each of those sheets is a column named Hours displaying how long an event occurred for each date (7:09, 8:21, 6:44, etc.). I have an Excel 2016 workbook having 12 sheets, 1 for each month.