View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.charting
nima
 
Posts: n/a
Default (Visually Appealing) Scientific Notation on the Y-Axis


I dont see how I can label each point with a cell reference anymore. I
varied the colors by points as you said (and changed overlap to 0 to
make it look better). I have 1 series with the 6 data points. I named
the series as a 6 cell range that corresponds to the 6 data points. In
the legend it labels the colors '1, 2, 3, 4, 5, 6'. I guess I still
dont understand how I get the names for each data point into the
legend.
<quoteThis only works in charts with one
series.</quote
If I follow your tutorial for making scientific annotated axes, then I
have to add another series, so wouldn't it remove the legend entries?

thank you for your patience.
Sorry for not posting in a new thread-i am new to this.


--
nima
------------------------------------------------------------------------
nima's Profile: http://www.excelforum.com/member.php...o&userid=30408
View this thread: http://www.excelforum.com/showthread...hreadid=500770