View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Lisa Wilke-Thissen[_2_] Lisa Wilke-Thissen[_2_] is offline
external usenet poster
 
Posts: 3
Default Problems with simple line graphs

Hi,

The graph is invoked again as a fresh call to the graph.
Why would we need to switch cols/rows?


Ave Set1 Set2 Set3 ...... Set10
C1 7.5 7.0 6.0 6.5 4.0
C2 7.5 7.5 7.5 7.5 6.0
C3 7.5 8.0 9.0 8.5 5.0


regarding your array, in a default chart C1, C2, C3 will be the legend.
Set1, Set2 ... will be the x-axis.
Therefore, in Word 2013 you have to choose "Chart Tools | Design | Data |
Switch Row/Column" for your chard.

--
Cheers,
Lisa