 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / December 2003Axis labels from data
Col A has years, such as 1990 thru 2003. Col B has numbers relevant to each year. Sales, taxes, inventory, whatever. I want a simple bar chart where the numbers are represented by the bars left to right. Easy. I want the categoty (X) axis label values to be 1990, 1001, etc instead of 1,2,3,... Not easy, or at least not obvious. Any ideas on how to do this? It seems like it should be built-in simple, but I've searched everywhere (except where the explanation is) to no result. Excel 2K Win 98 as well as Excel 2002 Win 2K. Thanks. Sorry, I kept looking after I posted and found it. It is simple, but perhaps not so visible. Step 2, "Series" tab, at the bottom. Even easier to do if you use row headers. Put a title above the data in column B but not above that in column A, so the data looks like this: Value 1995 15000 1996 15600 1997 16350 1998 17100 etc. Now select the range including the blank cell and column header, then make your chart. The blank cell is a clue to Excel to use the column without a header as the category labels and the row of the blank for series names. To plot multiple series, just extend the column headers and columns: Value Val-2 Other 1995 15000 12125 14220 1996 15600 13000 15250 1997 16350 12500 14800 1998 17100 13125 14500 - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ > Sorry, I kept looking after I posted and found it. It is simple, but perhaps not so visible. Step 2, "Series" tab, at the bottom. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.