In the text box, type the text that you want.Click the Text Box > Horizontal Text Box (or Vertical Text Box) on the Insert tab. In the chart, click where you want to start a corner of the text box, and then drag until the text box is the size that you want. On the Format tab, click Insert Shapes, and then click the Text Box icon. Creating a chart is easy, but what you can do with your chart after making it is what makes Excel such a great tool.Click the chart to which you want to add a text box. That’s it! You have created your first graph/chart in Excel and it literally takes just a few minutes. So now Excel will create the chart based on the data and dump it somewhere on your sheet.Now here’s what the chart looks like with the same data, but with X and Y switched.This chart is useful too because now I can see the scores for all the students per exam. Here you can change everything under the sun when it comes to your new chart.One neat thing you can do is click on Switch Row/Column under Data and the chart will instantly change with the data switched. That’s great, but what if I wanted to visualize the data in a different way? Well, by default, once the chart is added, you’ll see a new section at the top of the ribbon called Chart Tools with three tabs: Design, Layout and Format. Each student has four bars for their respective test scores.
![]() Edit Text Boxes In Chart In Excel 2008 Free To ChooseYou can always change the layout and it won’t mess up the chart in any way.Now just double-click on the text boxes and you can give the X and Y axis a title along with giving the chart a title also. Feel free to choose other layouts just to see how the chart changes. Here you’ll see a bunch of different ways we can change the layout.If you pick the one shown above, you chart will now look like this with the additional axis titles added for you. An easy way to do this is to click on the little down arrow with a line on top of it under Chart Layouts. Now let’s make our chart a little nicer by adding some titles, etc. Ezhu sundara rathrikal malayalam movie mp3 songs free downloadI’ll get a dialog window that will let me adjust any and all properties for that object. Here you can see all the different sections you can select:Suppose I click on Horizontal (Category) Axis and then click on Format Selection. The best part I like is right on the left part of the ribbon called Current Selection.There’s a drop down box that lets you pick any specific part of the chart and then you can click Format Selection to change the settings for just that one part. This is a very important tab because you can tweak pretty much every little detail about your chart here. If you have any questions about the tutorial or you own chart, please leave a comment. Again, you can use the Current Selection tool on the left and then change the border styles, font styles, arrangement of objects, etc.For the fun of it, I added a reflection effect to all the text on the chart and gave the whole chart a 3D effect of coming from the back to the front instead of just flat.In Excel, you can create far more complicated charts than the one I have shown here, but this tutorial was just to get your feet wet and understand the basics of creating a chart. Most of the options here basically let you move things to different locations on the chart.Finally, the Format tab under Chart Tools will let you adjust the formatting on every part of the chart. You can really customize your chart using these options. Go ahead and click on these and try them out to see what kind of effect they have on the chart.
0 Comments
Leave a Reply. |
AuthorBianca ArchivesCategories |