You've been advised to look at three if not four burn rate charts - if you do, you risk further confusion as some powders change position quite markedly between different sources. This is partly because the tests used may not be consistent between manufacturers / products, also because 'burn rate' is not a fixed standard with any relevant international standards, gauges to measure it against and so on. A powder may lie in one position in relation to others in one application eg 308 Win, but a different one in another cartridge with a different case capacity / charge size to bore ratio - say .30-06 or 7X57 Mauser.
That is why every burn rate chart published carries a warning somewhere on it that says it's for judging general broad applications and must never be used either to determine a specific application or to substitute charge weights from one powder to an apparently similar one lying alongside in a chart. A good example that we see in Europe is Czech Lovex brand SO65, a single-based tubular powder that in its manufacturer's burn rate chart is on the same line as Hodgdon VarGet. When VarGet was completely and utterly unobtainable in the UK for a period of 18 months some time back, people seized on this apparent interchangeability and thought SO65 would make a good alternative. It didn't! It is bulkier, has a considerably lower specific energy rating, and as seen in other people's burn charts, is also considerably slower burning - up to three steps slower in some I've seen. So, in typical optimal VarGet applications such as 308, it filled the case to compressed levels and produced mediocre MVs, large ES/SD values and often poor groups. Run it in 7mm-08 match loads, 7X64 or 7X57 sporting loads though and it can be a fine performer - a larger case and/or smaller bore giving a much lower expansion ratio.
The basic reason for having different burning rates is to provide a combination of peak chamber pressure and 'area under the [pressure/bullet movement/barrel-time] curve' that provides optimum MV within allowable pressures. Two primary factors determine what is a well suited powder in burning rate terms - the case size/capacity/charge weight to bore area ratio and the relative bullet weight in any given application. The larger the charge behind any bore size, the slower burning the powder needed. Have it too fast burning and the pressures go past red lines before the bullet has moved far enough down the barrel to increase the combustion chamber volume (internal fireformed case + the volume of the space behind the bullet base at any individual point of the charge burn.)
So small bore calibres require slower burning powders unless as in say .22 Hornet, there is a tiny case. The 45-70 and even the African dangerous game .458 Win Magnum by comparison use fast burners - because as the huge 45 cal bullet moves down the barrel, the combustion chamber volume rises very quickly.
A good way of seeing in practice how this works is to take a range of cartridges based on a single case, 308 Win and 30-06 being obvious examples. The 308 case has been used with little other change than neck diameter in five calibres on top of its original .30 - 243 Win, 260 Rem, 7mm-08 Rem, 338 Federal, 358 Winchester. Look up their loads in a loading manual and see what powders are used for the mid weight to heavy bullets, then look them up on a burn rate chart. 243 Win uses much slower burning grades than 338 or 358. This is purely case/charge to bore size ratio determined, sometimes called the effective expansion ratio, or how far the bullet must travel before combustion chamber volume doubles then trebles. (Although that looks at it in distance terms, the key factor is the time it takes a bullet to reach these waymarks as the % of the charge that has burned is determined largely by time from initial ignition and that in turn determines gas volume production.)
The other key factor that sees the need for different burning rates is bullet weight (affects inertia) in any given cartridge design, allied to the bearing surface length (which affects friction levels). A heavy, long bearing surface bullet has a great deal more resistance to acceleration / movement down the barrel than as light short one. Again, it comes back to distance travelled down the barrel / burn time and how quickly the combustion chamber volume is expanding as the charge burns through. Taking 308 Win as an example again, a 110gn bullet sees relatively fast burning powders employed because this short, low-inertia projectile moves forward then accelerates very quickly as soon as pressure builds up behind its base. A 230gn Berger Hybrid needs very much slower burning powders because the doubling of weight and much greater barrel contact sees a great reluctance to move at all, then much, much lower acceleration down the barrel. Use a powder suited to the 110 grainer with the 230 and the charge must either be reduced so much to keep pressures acceptable that the resulting MV will be very poor, or if the 110gn bullet load's powder and charge weight were simply substituted, the resulting pressure will break the rifle through a massive over-pressure before the bullet has moved more than a few millimeters. This is why a frequent cause of gun explosions with handloaded ammunition is the selecting the wrong powder when loading cartridges of different characteristics in a single session or getting plain confused over which powder is which - select very fast burning Vihtavuori N340 (a pistol/revolver cartridge powder) in mistake for N140 (a relatively slow burning rifle powder) and put 45 grains of the former behind a 150gn bullet in 308 Win and it's BANG, goodbye rifle, maybe bits of the shooter too, time!