If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Trouble formatting Date data
I am using a Line chart to plot specific milestones over a series of dates.
Each line in the chart represents the series of data and its progression over time. I have managed to create each series of data with my dates showing up in the X axis as a Time-Scale. However, I need my categories (the names of the milestones) to appear in the Y axis and I can't figure this out. I also want to experiment with having the dates appear in the Y axis, and categories in the X, although this does not appear to be possible. I believe this would represent my data more meaningfully. Your help is appreciated, - LB |
#2
|
|||
|
|||
Trouble formatting Date data
Here's one way:
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "LB" wrote in message ... I am using a Line chart to plot specific milestones over a series of dates. Each line in the chart represents the series of data and its progression over time. I have managed to create each series of data with my dates showing up in the X axis as a Time-Scale. However, I need my categories (the names of the milestones) to appear in the Y axis and I can't figure this out. I also want to experiment with having the dates appear in the Y axis, and categories in the X, although this does not appear to be possible. I believe this would represent my data more meaningfully. Your help is appreciated, - LB |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Phone call log, multiple fields for different times | Philip | Database Design | 18 | May 16th, 2006 01:27 AM |
Date range on reports | Mark_Milly | Setting Up & Running Reports | 10 | January 19th, 2006 03:49 PM |
Copy Cat Ain't Working | shep | Setting Up & Running Reports | 15 | September 12th, 2005 05:14 PM |
Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
Format on data to import to Access tables? (I need your advice) | Niklas Östergren | General Discussion | 5 | December 13th, 2004 02:54 PM |