close

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

Here's one way:

peltiertech.com/Excel/Charts/Y_CategoryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

quot;LBquot; gt; wrote in message
...
gt;I am using a Line chart to plot specific milestones over a series of dates.
gt; Each line in the chart represents the series of data and its progression
gt; over
gt; time. I have managed to create each series of data with my dates showing
gt; up
gt; in the X axis as a Time-Scale. However, I need my categories (the names
gt; of
gt; the milestones) to appear in the Y axis and I can't figure this out.
gt;
gt; I also want to experiment with having the dates appear in the Y axis, and
gt; categories in the X, although this does not appear to be possible. I
gt; believe
gt; this would represent my data more meaningfully.
gt;
gt; Your help is appreciated,
gt; - LB

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()