Posted:, 07:56 PM On 6/25/08 3:13 PM, in article 9absDaxw, '[email protected]' wrote: > Version: 2008 > Operating System: Mac OS X 10.5 (Leopard) > > I have made some graphs in excell with five different lines of data. In the > legend, all it states is 'series 1, series 2' etc. I want to change the name > of 'series 1' to 'MW-1'. What do I do? One way is to select the chart, and then select the series. ![]() You will see the series formula in the formula bar. Replace the Series 1, etc. With what ever you want to name the series. -- Bob Greenblatt [MVP], Macintosh bobgreenblattATmsnDOTcom. Posted:, 10:05 PM With the chart selected you should be able to go to the Toolbox->Formatting Palette->Chart Data pane->Edit. Button and then edit the name for any series you'd like. -Eric MacOffice Testing Microsoft 'Bob Greenblatt' wrote in message news:C4881B1C.ADBC0%[email protected]. > On 6/25/08 3:13 PM, in article 9absDaxw, > '[email protected]' wrote: > >> Version: 2008 >> Operating System: Mac OS X 10.5 (Leopard) >> >> I have made some graphs in excell with five different lines of data. In >> the >> legend, all it states is 'series 1, series 2' etc. I want to change the >> name >> of 'series 1' to 'MW-1'. What do I do? > One way is to select the chart, and then select the series. You will see > the > series formula in the formula bar. Replace the Series 1, etc. With what > ever > you want to name the series. > > -- > Bob Greenblatt [MVP], Macintosh > bobgreenblattATmsnDOTcom > -- This posting is provided 'AS IS' with no warranties, and confers no rights. Vlc for mac os x. MS Mac Newsgroups: MS Mac News & Updates. Camtasia for Mac makes it easy to create professional screencasts (capturing all actions on screen) for demonstration videos, instructional videos, and other screen-recording projects. Camtasia studio 8 download free. Change legend names excel Select the cell in the workbook that contains the legend name you want to change. HD Image of Formatting the chart legend mac erc. Excel charts add title customize chart axis legend and data labels Changing the format of numbers on axis labels. Press 'Set as Default' and then click 'Yes' to acknowledge the warning that some of your settings might change. Do not quit and restart Excel yet. Set the display and help languages. Hi everyone, I'm having a lot of trouble editing the legend titles in Excel 2011 for Mac. I've Googled around for solutions but they all seem to be for different versions of Excel, or they are for Windows Excel. I've created a line graph and in my legend the titles are Series 1, Series 2, etc., and I'd like to change these names to titles that are specific to my data. I have no idea how to do this. Right-clicking does not work. I remember when I used Windows, I could right-click and click select data and click Edit. ![]() However, there is no edit button on the Mac. Under Chart Layout, there is a Legend button, but there is no way to edit the actual text of the Legend. There are only text formatting options. Could someone please let me know a way to edit the names of my Legends? Apple quicktime download. This is rather urgent, as I have a deadline approaching. As I mentioned I'm using OSX 10.8.2 and am using Excel for Mac 2011.
0 Comments
Leave a Reply. |