How do I plot non-numeric values in a graph in Excel?
I need to plot non-numeric values in a graph in Excel.
Assume I have the following data... : X Axis Y Axis A L B M C N D O E P F Q G R I want such a graph R x Q x P x O x N x M x L x A B C D E F G i.e. ABCD on the x axis and lmno on the y axis and the small x points are the plots of AL, BM, CN etc.. |
Try this:
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Lax wrote: I need to plot non-numeric values in a graph in Excel. Assume I have the following data... : X Axis Y Axis A L B M C N D O E P F Q G R I want such a graph R x Q x P x O x N x M x L x A B C D E F G i.e. ABCD on the x axis and lmno on the y axis and the small x points are the plots of AL, BM, CN etc.. |
All times are GMT +1. The time now is 08:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com