Your suggestion led me to try another way of creating the chart that works: Insert Chart, select the label cell on the spreadsheet, select the data cell it corresponds to, repeat for each instance of label/data and then select the pie chart control from the elements gallery to create it.
- Open the Excel spreadsheet file you want to edit. Find the spreadsheet you want to edit on your.
- Click Add Chart Element to modify details like the title, labels, and the legend. Click Quick Layout to choose from predefined sets of chart elements. Click one of the previews in the style gallery to change the layout or style. Click Switch Row/Column or Select Data to change the data view. Click Change Chart type to switch to a different kind.
You begin with smart templates that have been well-formatted. Then you can point and click to edit chart or graph. Add data directly into the attached text boxes and the shapes (bar, column, pie and line etc.) will change automatically. See how to do it with our amazing chart and graph software for Mac easily in the following tutorial.
Open a Chart and Graph Template
On the File menu, point to New.-> Click Chart, and then double click the icon of your desired chart, such as bar chart.
A blank canvas and the necessary libraries open automatically.
How To Edit Text In Chart For Excel Macd
Add Chart and Graph Shapes
Drag and drop a chart or graph from the left library to the canvas.
Format Chart and Graph Shapes
Resize Chart and Graph
Drag the green square handles to resize shapes. Drag the yellow control point to resize subshape.
Set Fill Style
Select a series of sub shape in any category or a legend sub shape > Change the selected shape fill style, then Edraw applies the fill style to the series shapes.
Edit Chart and Graph Shapes through Floating Menu
Move the cursor over the chart or graph to show the floating action button. -> Rest the cursor over the floating button. -> Point and click the floating menu to edit the shape such as add a category or hide data label.
Click the Appearance Options and then a dialogue box pops up. You can format the shape in more aspects in it.
Lay out Chart and Graph
- To align multiple shapes vertically or horizontally, select the shapes you want to align, then, click the Align button under Home tab to align shapes. When moving a shape, the dynamic guidelines show to help you align it with the nearby shapes.
- To distribute three or more shapes at regular intervals, select the shapes, and then, click Distribute in Arrange group under Home tab.
- To locate the whole diagram in the center, click Center in the Arrange group under Home tab.
Add Text to Chart and Graph
- To add text to a shape, select it, and then type. When you are finished typing, click outside the text box. Our chart and graph shapes are smart vector shapes. After you enter new numbers in the data labels, relevant shapes will change automatically to reflect the data changes.
- Press Ctrl + 2 to add more text boxes. Press Ctrl + shift + 2 to adjust text box.
- Choose a different font under Home tab. Customize the size, color and alignment by clicking relevant menus.
Change Chart and Graph Theme
By choosing a suitable Chart and Graph theme, you can add professionally designed fill, line and text style to your chart altogether at 1 click. This saves you lots of troubles in formatting.
Switch to Page Layout tab, select another theme.
Add Background to Chart and Graph
You can add background to make your file more beautiful. Adding your company logo to the background and using this background as master template are also a good way to promote your business. To add a background, go to Page Layout tab and then:
- Click a color for colorful background.
- Click Choose Background to select a predefined background.
- Click Remove Background if you don't want the added background anymore.
- Switch to View tab and then click Background View to edit and personalize the background.
Save or Export Chart and Graph
Click Save on File tab to save as the default format. Choose Saveas on File tab to save as other formats.
You can choose to save in local files or save in your Cloud. Saving it in Team Cloud can share it with more people.
Not everybody has a copy of Edraw so there are times when you need to export diagrams from Edraw into another format. This may be for viewing online within a webpage; for inclusion in another application, such as PowerPoint; or just for printing.
Hit Export & Send under File to export the file as other formats.
How To Edit Text In Chart For Excel Mac
Print Chart and Graph
- Click File tab and then choose Print. A preview of your chart automatically shows.
- To view each page, click the arrows below the preview.
- TIP: Use the zoom slider below the preview to magnify the image of the chart.
- To go back to your chart or graph and make changes before you print it, click the top left arrow.
If the canvas is larger than the print paper, the drawing will be printed on more than 1 paper. To print it on only 1 paper,
click More Print Setup... and then choose Fit to.
Here are some free and fully customizable chart and graph examples. Download them to get inspired and get started quickly.
Further Reading:
Try an easy and effective Chart and Graph tool - Edraw. Download it through the links below.
The key to understanding charts is through the use of legends. Legends are automatically created everytime we create a graph or plot our data.
Figure 1. Final result: How to edit legend
In the chart above, the legend is located in the top center of the graph, showing a bulleted list with text “A” and “B Sales”.
When we encounter an Excel chart without a legend, we can easily add a legend through these steps:
Add legend to an Excel chart
Step 1. Click anywhere on the chart
Step 2. Click the Layout tab, then Legend
Step 3. From the Legend drop-down menu, select the position we prefer for the legend
Example: Select Show Legend at Right
Figure 2. Adding a legend
The legend will then appear in the right side of the graph.
Figure 3. Output: Add legend to a chart
The legend in a chart can be edited by changing the name, or customizing its position and format.
How to change legend name?
There are two ways to change the legend name:
- Change series name in Select Data
- Change legend name
Change Series Name in Select Data
Step 1. Right-click anywhere on the chart and click Select Data
Figure 4. Change legend text through Select Data
Step 2. Select the series Brand A and click Edit
Figure 5. Edit Series in Excel
The Edit Series dialog box will pop-up.
Figure 6. Edit Series preview pane
Step 3. Delete the current entry “=Sheet1!$C$2” in series name and enter “A” into the text box.
Figure 7. Changing legend text
The legend name is immediately changed to “A”.
How To Edit Text In Chart For Excel Macro
Figure 8. Output: How to rename legend
Change legend name
Step 1. First, we must determine the cell that contains the legend name for our chart by clicking the chart. As shown below, the column chart for Brand B is linked to cells D2:D7.
Figure 9. Change legend text
Step 2. Since D2 contains the legend name, we select D2 and type the new legend name “B Sales”.
Figure 10. Change legend name
How To Edit Text In Chart For Excel Macros
As shown above, the legend name on the chart is instantly updated from “Brand B” to “B Sales”.
How to edit legend?
Legends can be customized by changing the layout, position or format.
How to change legend position?
It is very easy to change the legend position in Excel. Simply click the chart, then click the Layout tab. Under Legend, choose the preferred position from the drop-down menu.
Figure 11. Change legend position
Example:
Select Show Legend at Top from the drop-down menu. As shown below, the legend is transferred to the top of the chart.
Figure 12. Output: Change legend position
How to edit legend format?
In order to change the format, right-click the legend and select Format Legend.
Figure 13. Edit legend through Format Legend
The Format Legend dialog box will appear. There are several options where we can change the legend position, fill, border color, border styles, and other formatting options.
How To Edit Text In Chart For Excel Machine
Figure 14. Format legend preview pane
Example:
We want to fill the legend box with Aqua, Accent 5, Lighter 60%.
We click Fill, then tick Solid Fill.
Figure 15. Change legend fill
Choose the color we prefer and click OK. The fill color will automatically be updated to the chosen color.
Figure 16. Select fill color for legend
We can add more formatting changes. Below chart shows the legend format with a 5% pattern fill and an orange border color.
Figure 17. Final result: How to edit legend
Instant Connection to an Expert through our Excelchat Service
Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.