relopmega.blogg.se

You can read more about it in my Excel Camera Tool Tutorial.Īnother alternative is In-cell charts, but that’s a lesson for another day. ve3oat - format x-axis is possible with line charts and using Type Date in Tab:Scale of the format x-axis dialog allows to perform the requested alignment of. There are limitations to the Camera Tool though. If you’re unfortunate enough to still have Excel 2003 then you can insert a column chart and use Excel’s Camera tool to take an image of your chart, and then use the handles to turn it on its side. Note: The Bar Chart is only available in Excel 2007 and Excel 2010.

The best solution is to use a bar chart which plots the columns horizontally like this: Now, while this is fine for year and month labels that are easily interpreted in an abbreviated form, what if you’ve got labels like products or regions that need the full label displayed? Read on for the solution. Now, doesn’t that look better? To create this effect you simply need to house your year labels in a separate column to your month labels, like this:Įxcel is clever enough to know that the year and month columns are your axis labels and it automatically nests them for you. In Excel chart, Axis labels are displayed horizontally, if you want to change X Axis Labels direction from horizontal to vertical.