Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare date to column data | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Conditional Formatting not applied to data exported from Access | Excel Worksheet Functions | |||
Date formatting problem | Excel Discussion (Misc queries) | |||
Retain PivotTable formatting after "Refresh Data" | Excel Discussion (Misc queries) |