Re: How to create a chart with Microsoft Excel.


Adekoya Rasak
 

hello Maria,

this is quite detailed. I really appreciate. I will try to explore and
surely send you feedback. Meanwhile, is it possible to export the pie
chart or bar chart to microsoft office word as well as save it as
image (jpeg format)?

If yes, how?
In conclusion, I am grateful. if I need further clarification, can I
contact you?

On 05/04/2017, Maria Kristic <maria.kristic@...> wrote:
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...

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
Lab 75%
Golden 10%
Shepherd 5%
Lab/Golden 5%

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.

Regards,
Maria


-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Adekoya
Rasak
Sent: Wednesday, April 5, 2017 6:18 AM
To: main@jfw.groups.io
Subject: How to create a chart with Microsoft Excel.

Hello,

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.

Thank you.

--


*ADEKOYA, Rasak*.
*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

+2348034829045

<https://twitter.com/Iamrasakadekoya>@Iamrasakadekoya
<https://twitter.com/Iamrasakadekoya>

asiwaju.rasak29


*CONFIDENTIALITY NOTICE:*
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.







--


*ADEKOYA, Rasak*.
*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

+2348034829045

<https://twitter.com/Iamrasakadekoya>@Iamrasakadekoya
<https://twitter.com/Iamrasakadekoya>

asiwaju.rasak29


*CONFIDENTIALITY NOTICE:*
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.

Join {main@jfw.groups.io to automatically receive all group messages.