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

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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.