View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Gawayne Gawayne is offline
external usenet poster
 
Posts: 1
Default Graph lines formatting in Excel 2007

I appear to have a couple of problems in Excel 2007 SP1

i) Although the help says you can reformat multiple lines by using the Ctrl
button and the mouse, it doesn't seem to work .. I highlight the first line
and when I try the second it deselects the first . Any ideas

ii) I'm using Excel to display sets of spectra .... the default line
thickness is 2.25pt and I want to set the default to 0.25 pt, how do I do it
??

iii) I resized a graph of 160 lines by hand (yawn, yawn) and saved it as a
template ... however when I draw a new graph from the 160 lines and apply the
template, Excel tells me that I've exceeded the 256 limit on lines drawn and
obly draws about 70 graphs ..... I suspect this is 2 x 160 - 256 so Excel is
drawing the lines at the default, then redrawing them at the template size
and removing the default. How do I get around this ? (Changing them by hand
one-at a time is not accceptable).