Creating Graphs in M icrosoft Excel Graph One Step1: Continuing on from the table, create a new work sheet Step2: Rename both the sheets. Sheet with the table name Amour Cafe and the sheet that will have graphs, call it graphs. T o do this double click on the sheet part down the bottom. Step3: T o get chart options up, go to the top tool bar across to insert, then go down to chart. Click chart and options will appear. Free best antivirus for mac. ![]() Best mailing ap for mac. (Options are the different charts available to use). Jacqueline McAlister Click the + symbol at the bottom of. ![]() To do it, go back to the table in Excel you used to create the line chart, and highlight the data points that make up the Y-axis (in this case, the dollar amount). Then, copy it and paste it to the row below so there are two identical data series. • Double-click on one of the blue data bars in the graph and choose Format Data Series from the context menu. The Format Data Series dialog box opens. • Select Fill Options or the Fill & Line icon in the Format Data Series dialog box. • Select Picture or texture fill under Fill. • Select File if you want to use a picture saved on your computer. • Select Online if you want to search online for a picture to use. • Find and select the image you want to use. • Select Insert to add the picture. • Select the Stack button. • Close the Format Data Series dialog box. Microsoft media creation tool 1809. The blue colored bars in the graph are replaced with the image selected. • Repeat the above steps to change the other bars in the graph to pictures.
0 Comments
Leave a Reply. |