Unusual Chart Type?

Follow your instincts, and use numbers for states, {1,2,3,4,5} for
{A,B,C,D,E}. Make your chart. Then use the technique on this page to put
the labels where you want them:

http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

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

MWE wrote:

I am running Excel2000. I wish to create a chart that does not seem to
be supported in Excel. The data consists of a table of dates and
“states” (let’s call them A, B, C, D and E). One column is dates and
the next is states. Dates will be in order. A given date could have
any state. So the first col might be {03-Apr, 04-Apr, 05-Apr, 06-Apr,
07-Apr, 08-Apr, …} while the second might be {A,B,D,B,B,E, …}. I wish
to plot this data with the state on the Y axis and the date on the X
axis. I need an X-Y plot, not cols or bars. This is easy if the
states are numbers. But I cannot find a way to do this if the states
are alpha. Alternatively, I could plot the data using numbers for
states, eg., 1=A, 2=B, etc) and then change the Y axis labels – if I
knew how to do that. Ultimately I wish to do this under VBA control.

Any help would be appreciated. Thanks


---
Message posted from http://www.ExcelForum.com/

You have the right idea. Replace the A..E with numbers 1..5.

To create labels along the y axis, create a dummy series that consists
of (0,1), (0,2),...(0,5). 'Remove' the default y-axis labels (double-
click the axis, then from the Patterns tab set the parameters to
'None'). Now, use Rob Bovey's XY Chartlabeler (www.appspro.com) or
John Walkenbach's ChartTools (www.j-walk.com) to add labels to this
dummy series.

To create sharp transitions, see the 'Step Chart' page of my web site.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , MWE MWE.15qj39
@excelforum-nospam.com says...
I am running Excel2000. I wish to create a chart that does not seem to
be supported in Excel. The data consists of a table of dates and
=3Fstates=3F (let=3Fs call them A, B, C, D and E). One column is dates and
the next is states. Dates will be in order. A given date could have
any state. So the first col might be {03-Apr, 04-Apr, 05-Apr, 06-Apr,
07-Apr, 08-Apr, =3F} while the second might be {A,B,D,B,B,E, =3F}. I wish
to plot this data with the state on the Y axis and the date on the X
axis. I need an X-Y plot, not cols or bars. This is easy if the
states are numbers. But I cannot find a way to do this if the states
are alpha. Alternatively, I could plot the data using numbers for
states, eg., 1=A, 2=B, etc) and then change the Y axis labels =3F if I
knew how to do that. Ultimately I wish to do this under VBA control.

Any help would be appreciated. Thanks


---
Message posted from http://www.ExcelForum.com/

See the response to the same question in the same newsgroup.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , MWE MWE.15qj36
@excelforum-nospam.com says...
I am running Excel2000. I wish to create a chart that does not seem to
be supported in Excel. The data consists of a table of dates and
=3Fstates=3F (let=3Fs call them A, B, C, D and E). One column is dates and
the next is states. Dates will be in order. A given date could have
any state. So the first col might be {03-Apr, 04-Apr, 05-Apr, 06-Apr,
07-Apr, 08-Apr, =3F} while the second might be {A,B,D,B,B,E, =3F}. I wish
to plot this data with the state on the Y axis and the date on the X
axis. I need an X-Y plot, not cols or bars. This is easy if the
states are numbers. But I cannot find a way to do this if the states
are alpha. Alternatively, I could plot the data using numbers for
states, eg., 1=A, 2=B, etc) and then change the Y axis labels =3F if I
knew how to do that. Ultimately I wish to do this under VBA control.

Any help would be appreciated. Thanks


---
Message posted from http://www.ExcelForum.com/

You didn't delete the Y axis, did you? You need to keep it, but hide the
labels and tick marks (double click on the axis, and click on the
Patterns tab). The dummy series lines up along the Y axis; the data
labels on the points serve as substitute axis labels.

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

MWE wrote:

Tushar: thank you for your reply. I was able to find, download and
installl Rob Bovey's XYChartlabeler addin. I played around with it and
it seems pretty useful. However, I must be missing something because I
do not understand what the dummy series does and cannot make the
XYChartlabeler operate on the correct axis.
1. I created the dummy series as two cols of 5 elements each, the
first with all zeros, the 2nd with 1, 2, 3, 4, 5
2. using the method you outlined I eliminated the Y axis labels in the
target chart, i.e., the one with real data (X=dates; Y=States)
3. but all I can do using Rob Bovey's XYChartlabeler tool is change
the labels on the X axis (Dates). I want to change the labels on the Y
axis (States)

I must be doing something wrong

MWE

Tushar Mehta wrote:

*You have the right idea. Replace the A..E with numbers 1..5.

To create labels along the y axis, create a dummy series that
consists
of (0,1), (0,2),...(0,5). 'Remove' the default y-axis labels
(double-
click the axis, then from the Patterns tab set the parameters to
'None'). Now, use Rob Bovey's XY Chartlabeler (www.appspro.com) or
John Walkenbach's ChartTools (www.j-walk.com) to add labels to this
dummy series.

To create sharp transitions, see the 'Step Chart' page of my web
site.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , MWE MWE.15qj39
says...

I am running Excel2000. I wish to create a chart that does not

seem to

be supported in Excel. The data consists of a table of dates and
=3Fstates=3F (let=3Fs call them A, B, C, D and E). One column is

dates and

the next is states. Dates will be in order. A given date could

have

any state. So the first col might be {03-Apr, 04-Apr, 05-Apr,

06-Apr,

07-Apr, 08-Apr, =3F} while the second might be {A,B,D,B,B,E, =3F}.

I wish

to plot this data with the state on the Y axis and the date on the

X

axis. I need an X-Y plot, not cols or bars. This is easy if the
states are numbers. But I cannot find a way to do this if the

states

are alpha. Alternatively, I could plot the data using numbers for
states, eg., 1=A, 2=B, etc) and then change the Y axis labels =3F

if I

knew how to do that. Ultimately I wish to do this under VBA

control.

Any help would be appreciated. Thanks


---
Message posted from http://www.ExcelForum.com/

*



---
Message posted from http://www.ExcelForum.com/