Forum Discussion
Cannot change axis bounds
I hope this is the right place to ask, but I have an issue with Excel 2016. When I plot a graph, Excel won't let me change the axes minima and maxima. I can enter a value into the respective fields (...
Hey guys (@dvirant , NikolinoDE , robalten242 , WFRAI ) !!!! I was looking at the excel configuration and nearly by chance I found the solution.... it's gonna sound unbelievable but it was this silly. Apparently the error appears when you don't have well defined the decimal and grouping symbol in your system in the Additional settings in the Region tab of the control panel of windows (I'd never changed anything there so honestly I don't know if it was an update that generated that change or what...) so in the excel options ( in the advanced tab) we all have the default setting that is "Use system separators" and that was messing everything up because every time we wrote excel detected that it was not the correct format and take it to the auto bound again. Give it a try and tell me how it went. 😉
To play with variants
Power Query
let Start = Number.From(#date(2022,7,1)), End = Number.From(#date(2023,6,30)), Date = Table.FromList({Start..End}, Splitter.SplitByNothing(), {"Date"} ), Week = Table.AddColumn( Date, "Week #", each "Week " & Text.From(Number.IntegerDivide([Date] - Start, 7) +1), type text), DateFormat = Table.TransformColumnTypes(Week,{{"Date", type date}}) in DateFormatDynamic array
=LET( start, DATE(2022,7,1), end, DATE(2023,6,30), date, SEQUENCE( end-start+1,,start), week, "Week " & INT((date-start)/7 ) + 1, IF({1,0}, date, week ) )Hi Imi_Jay
(31/6/2023 doesn't exist, adjusted to 30/6/2023 below). Not sure where/how you want to add that column so the following might not be exactly what you want... (Edited)
let StartDate = #date(2022,7,1), EndDate = #date(2023,6,30), Days = Duration.Days(EndDate - StartDate) +1, Weeks = Number.RoundUp(Days / 7), Table = Table.FromColumns( { List.Dates(StartDate, Days, #duration(1,0,0,0)), List.FirstN( List.TransformMany(List.Numbers(1, Weeks), each List.Numbers(1, 7), (w,d)=> "Week " & Text.From(w) ), Days ) }, type table [Date=date, Fiscal Week=text] ) in TableThis creates a Table of 2 columns:
- Thanks!
