Re: How to create a chart with Microsoft Excel.
I will give you an example with a pie chart...my general comments should apply to any chart, though. I am using a different setup from yours (I am using JAWS 18, Windows 10, Office 2016), so you may have to Google something if my instructions are different from what happens on your end...toggle quoted messageShow quoted text
Basically, the steps in creating the chart are to set up the data properly in the sheet, insert the chart, then format the elements you want by selecting them and choosing format options from the context menu.
Data Arrangement: You want your categories in the first column and then each of your data series in columns to the right of that. The top row of your chart data contains your series labels; the category column should have no label.
For example, here is my data table for a pie chart example. Notice that row 1 column 1 is blank (i.e., no category label). My series is called "Percentage of Leader Dogs" (i.e., series label is in row 1, column 2). My categories (the dog breeds) go down column 1, and the values for my categories (i.e., the percentages) go down column 2.
Percentage of Leader Dogs
Insert The Chart: Insert tab of the ribbon > select the type you want from the Chart group.
In my pie chart example, Insert > Insert Pie or Doughnut Chart > Pie. Once you select the major chart category (i.e., "Pie or Doughnut" above), the chart types show in a grid; you may find it easier to navigate this grid and select a chart type using the Touch Cursor.
Quickly Access the Chart: Press CTRL+SHIFT+O to display the list of objects, and select your chart by pressing ENTER on it. Press CTRL+INSERT+C to display information about the chart in the Virtual Viewer. Or, once the chart is selected, you can also use the Touch Cursor to explore the chart elements.
Format Chart Elements: With the chart selected, go to the Format contextual tab of the ribbon in the Chart Tools portion of the ribbon that has appeared now that you have selected the chart. In other words, you can press ALT to activate the ribbon tabs, RIGHT ARROW several times...past the static ribbon tabs that are always there...you will first hear "Chart Tools, Design tab" as you keep arrowing right, arrow right once more to hear "Format tab". Then, TAB to get in to the Elements list, UP/DOWN ARROW to choose what you want, and press ENTER to select it. That chart element is now selected; press the APPLICATIONS key to access the menu of things you can do on this element. Some things, like the "Edit Text" option for changing a chart title, are edit fields; other things, like "Format...", "add Trendline...", and other items, open panes to which you F6/SHIFT+F6 to gain focus and then adjust items in them.
Back to my pie chart example, the title is currently blank when the chart is inserted. In the Format contextual ribbon tab of the Chart Tools group, select Chart Title in the Elements list, and press ENTER. The chart title is now selected. Press the APPLICATIONS key, and select "Edit Text". This edit field has accessibility issues, so you won't get too much feedback in it, but you can edit it. Once you have selected the "Edit Text" item, JAWS won't indicate that you are in an edit field, but you are. Press CTRL+END to get to the bottom of the text, and hit BACKSPACE several times to make sure all text is deleted (you want the default text of "Chart Title" not to be there). Type in the new title, and when done typing, activate the APPLICATIONS menu, and select the "Exit Edit Text" option to exit edit mode. To quickly check if your new title is there, press CTRL+SHIFT+O to select an object; JAWS will now identify the chart by the title you gave. If you need to edit the title further, repeat the above process, and type it in from scratch again.
Adding Axis Labels: This doesn't apply to pie charts, but in chart types like bar charts that you mention below, you would want to add axis titles to make the data more understandable. To do this, in the Chart Tools Design contextual tab of the ribbon that appears when a chart is selected, press SPACE on the "Add Element" item, and select Axis Titles > [AxisTitleYouWantToAdd]. Repeat the process to add the label for the other axis. Once you have added the two labels for the vertical and horizontal axes, follow the procedure as described above to edit them in the same way as you would edit a chart title (i.e., select the label from the Chart Elements list of the Format contextual ribbon tab, activate the Context Menu with APPLICATIONS key and select "Edit Text", etc.) To check that your axis title is there, press CTRL+SHIFT+O to select objects, select the chart, and press CTRL+INSERT+C to display the chart in the Virtual Viewer; you will be told the labels that you put in as you move through the information.
Hope this helps get you started.
From: email@example.com [mailto:firstname.lastname@example.org] On Behalf Of Adekoya Rasak
Sent: Wednesday, April 5, 2017 6:18 AM
Subject: How to create a chart with Microsoft Excel.
I will like to know if anyone here have a tutorial on how to create a chart on Microsoft excel. I mean chart like infographic that can be used to indicate percentage either in a graph format, circle with shade or any other format.
I use Jaws 17, Microsoft excel 2007 on widno 8.1
I look forward to your suggestions.
*Leadership, Management & Content Consultant* at www.360Connect.com.ng <http://www.360connect.com.ng/>
If you want to significantly multiply your productivity & profit, talk to me
This e-mail and any attachment are confidential and may be privileged or otherwise protected from disclosure. It is solely intended for the
person(s) named above. If you are not the intended recipient, any reading, use, disclosure, copying or distribution of all or parts of this e-mail or associated attachments is strictly prohibited. If you are not an intended recipient, please notify the sender immediately by replying to this message or by telephone and delete this e-mail and any attachments permanently from your system.