View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Ben Hill Ben Hill is offline
external usenet poster
 
Posts: 2
Default Change y-axis to category in a column chart

Del Cotter wrote in
:

On Sun, 8 Jul 2007, in microsoft.public.excel.charting,
Ben Hill said:
I'd like my column chart y-axis to show the words instead of 4, 3,

2,
1

I have read a little about dummy series and I don't understand it
yet, but it seems to apply to an X-Y scatter rather than to my
situation. Is my wish a possibility?


That's okay, because "chart type" isn't something you're forced to
have all the same. It can be different for every series. You

simply
add that dummy series (which will look like another column series

at
first, but don't worry!) and then change it to an XY series.


Thanks. It did work. I don't know how yet, but I works. I'll keep
playing with it.