Re: How to create a chart with Microsoft Excel.


Maria Kristic
 

You can copy/paste the chart in to a Word document, or you can save it as an image. Take a look at these two Office support articles:

Copying/Pasting Excel Chart to Other Office Program: https://support.office.com/en-us/article/Copy-an-Excel-chart-to-another-Office-program-4ba759cc-62f3-422c-bd75-3fc83b06bb6b?ui=en-US&rs=en-US&ad=US

Saving Excel Chart As Image: https://support.office.com/en-us/article/Save-a-chart-as-a-picture-in-Excel-for-Windows-254bbf9a-1ce1-459f-914a-4902e8ca9217

Some keyboard modifications to those articles: Paste Special can be invoked with ALT+CTRL+V; to select an object, CTRL+SHIFT+O to activate JAWS' Object List feature, and select it from the list; right-click of course refers to using the APPLICATIONS key...

Hope it helps! Sure, you can contact me...since I have a different Office version to yours, I might not be able to give you the best step-by-step, and Googling an article on Office 2007 specifically might be more helpful, but like I said, if you wish to get in touch, feel free!

Regards,
Maria

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

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@gmail.com> 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.