M
MWE
I am running Excel2000. I wish to create a chart that does not seem t
be supported in Excel. The data consists of a table of dates an
“states” (let’s call them A, B, C, D and E). One column is dates an
the next is states. Dates will be in order. A given date could hav
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 wis
to plot this data with the state on the Y axis and the date on the
axis. I need an X-Y plot, not cols or bars. This is easy if th
states are numbers. But I cannot find a way to do this if the state
are alpha. Alternatively, I could plot the data using numbers fo
states, eg., 1=A, 2=B, etc) and then change the Y axis labels – if
knew how to do that. Ultimately I wish to do this under VBA control.
Any help would be appreciated. Thank
be supported in Excel. The data consists of a table of dates an
“states” (let’s call them A, B, C, D and E). One column is dates an
the next is states. Dates will be in order. A given date could hav
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 wis
to plot this data with the state on the Y axis and the date on the
axis. I need an X-Y plot, not cols or bars. This is easy if th
states are numbers. But I cannot find a way to do this if the state
are alpha. Alternatively, I could plot the data using numbers fo
states, eg., 1=A, 2=B, etc) and then change the Y axis labels – if
knew how to do that. Ultimately I wish to do this under VBA control.
Any help would be appreciated. Thank