If its a Column chart, change it to a Bar chart (Chart menu Chart Type).Are the months numeric If not, either change the data to display dates (full dates, like 1-Jan-2006), or change to display integers like 1, 2, 3, etc.This display can be adjusted using a custom number format, something like Month 0 (where 0 is a zero character), or you can just leave the numbers and use a Y axis title of Month.
Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions keen learner wrote in message news:AD219289-F82A-4400-AE7C-AA1812DE4115microsoft.com. Hi I am using a line graph with the source data from a table in this format Model 1 Model 2 Model3 Month 1 month 2 month 2 Without changing the format of my table, how do I display on the graph the models as the Legend and the months on the left. Let me insert a standard column chart and lets look at how Excel plots the data. So when I reverse the order, the axis moves along with Cuba. ![]() My heart sank when I looked at a multi-line cell realised I needed each line in a separate column. Worked a charm. Yes, I could have done it other ways but all of them would have been so much longer. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |