Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Exporting charts and tables

From: SPSS Statistics Essential Training (2011)

Video: Exporting charts and tables

In this final video, I want to show you how to take the charts that you create in SPSS and export them as HTML and as image files as either JPEG or PNG or some other format that you can then use to integrate into your word processor documents, into your presentations, or into your web pages, as a way of sharing the results of your analysis. For this example, I use the same data set, Searches.sav, and what I am going to do is I will just make two or three sample charts very quickly and then show how to export them. In this particular case, I'll make a bar chart.

Exporting charts and tables

In this final video, I want to show you how to take the charts that you create in SPSS and export them as HTML and as image files as either JPEG or PNG or some other format that you can then use to integrate into your word processor documents, into your presentations, or into your web pages, as a way of sharing the results of your analysis. For this example, I use the same data set, Searches.sav, and what I am going to do is I will just make two or three sample charts very quickly and then show how to export them. In this particular case, I'll make a bar chart.

I go into Graphs, and then the Chart Builder, then I am going to make a bar chart of regional variation and interest in SPSS, because that showed up in our regression results. So I am going to come down and get the Census Bureau Region, put that in the x-axis, and get SPSS and make that the variable as being charted here. I put arrow bars on it and click OK. And what I see is that the west has much, much lower interest in SPSS as a relative search term than the other three regions, which would explain the curious results of our output in the linear regression.

I am going to change these just for a moment, just a small amount. Really I think all I am going to do is change the colors. You can change them however you want. You can make individual bars of different colors. I will just press Close and close that. So there's one chart. Next thing, I am going to make a scatter plot. Go to Graphs, back to the Chart Builder. This time I will choose Scatter, and I will bring that up, and I am going to look at the association between Business Intelligence and interest in SPSS.

Now I'll hit OK and I have got a scatter plot there. I am going to clean it up slightly. I don't need all those decimal places. So I am going to number format and change those to zeros. I will do the same thing over here, and then what I am going to do is I am going to change those to solid red circles. Then I am going to add two lines because I can. There is a regression line, but what I am going to do with that regression line is actually going to change it what calls a Smoother that follows the pattern a little more closely.

Then I am going to change the color of that to Grey. And then I will also add a linear regression line. It's added a Quadratic. That's okay. I just change it to Linear. I can delete that, and I am going to change the color of the linear regression line. I will make it grey also, perhaps a darker grey, and there's my scatter plot. And now what I can do is I can take my charts and I can export them. Now it's easiest to just simply export everything in the output.

However, you may not want to have all of the texts and all the other information. So for instance, this right here is the Log. You see I click on that Log it's highlighted. I can delete that if I want. This is the title of the chart. We have something called notice that doesn't show up. It's there but it's hidden. I find it convenient sometimes to just come over here, and get everything I don't want and delete it. You can do that or you can leave it in. I will delete them for one and leave them in for the other. But what I am going to do now is I am going to save my output and then come to File, to Export.

And what you have is a lot of options here. You can export them as a Microsoft Word document. You can download them, as an Excel file, as a PDF straight into PowerPoint. Now I personally find the easiest way of dealing with these is to export them as an HTML file because what that does is it exports the entire output as a single HTML file, but it also downloads all the graphics as individual files. You can do JPEGS if you want. On the other hand, if you're going to be putting this up on the web, PNG files can be more helpful.

The entire output is a single HTML file and each chart is a separate PNG file. All I need to do now is tell it where I want to save things. I click on Browse and I created a folder already called SPS Output in HTML and PNG. So I am going to double-click on that and then I'll just call it Exported Output, press Save, and I will press OK. We have Exporting progress. There are times when that can take quite a while. This is a very short output. Now I'll show you if I go to the folder that I have created, SPSS output in HTML and PNG, I can double-click on that.

Then you see we have an HTML file here. I double-click on that. This has the entire results. See these, for instance, are the notes that say they don't show but they are there, and it has its graphics also. On the other hand, I also have each chart as a separate PNG file right here and I can open it with the Windows Photo Viewer and there it is. In that way, I can take these graphics and put them into whatever program I want, how I feel like and best present them.

That ends the final presentation on how to take the results of your analysis and get a way to present them to others that will make it easier for you to tell your analytic narrative, to make sense out of your results, to find surprises hopefully and insights that will give you an advantage in conducting your own work, and make it easier to sell your points to others.

Show transcript

This video is part of

Image for SPSS Statistics Essential Training (2011)
SPSS Statistics Essential Training (2011)

52 video lessons · 20093 viewers

Barton Poulson
Author

 
Expand all | Collapse all
  1. 2m 58s
    1. Welcome
      1m 5s
    2. Using the exercise files
      40s
    3. Using a different version of the software
      1m 13s
  2. 19m 0s
    1. Taking a first look at the interface
      11m 49s
    2. Reading data from a spreadsheet
      7m 11s
  3. 21m 54s
    1. Creating bar charts for categorical variables
      7m 18s
    2. Creating pie charts for categorical variables
      2m 54s
    3. Creating histograms for quantitative variables
      5m 45s
    4. Creating box plots for quantitative variables
      5m 57s
  4. 33m 10s
    1. Recoding variables
      5m 33s
    2. Recoding with visual binning
      5m 33s
    3. Recoding by ranking cases
      5m 26s
    4. Computing new variables
      5m 37s
    5. Combining or excluding outliers
      5m 21s
    6. Transforming outliers
      5m 40s
  5. 28m 12s
    1. Selecting cases
      6m 44s
    2. Using the Split File command
      5m 12s
    3. Merging files
      5m 33s
    4. Using the Multiple Response command
      10m 43s
  6. 22m 14s
    1. Calculating frequencies
      8m 43s
    2. Calculating descriptives
      5m 31s
    3. Using the Explore command
      8m 0s
  7. 16m 3s
    1. Calculating inferential statistics for a single proportion
      6m 6s
    2. Calculating inferential statistics for a single mean
      5m 39s
    3. Calculating inferential statistics for a single categorical variable
      4m 18s
  8. 30m 43s
    1. Creating clustered bar charts
      7m 10s
    2. Creating scatterplots
      5m 8s
    3. Creating time series
      3m 24s
    4. Creating simple bar charts of group means
      4m 17s
    5. Creating population pyramids
      3m 0s
    6. Creating simple boxplots for groups
      3m 3s
    7. Creating side-by-side boxplots
      4m 41s
  9. 45m 28s
    1. Calculating correlations
      8m 17s
    2. Computing a bivariate regression
      6m 27s
    3. Creating crosstabs for categorical variables
      6m 34s
    4. Comparing means with the Means procedure
      6m 33s
    5. Comparing means with the t-test
      6m 4s
    6. Comparing means with a one-way ANOVA
      6m 30s
    7. Comparing paired means
      5m 3s
  10. 24m 30s
    1. Creating clustered bar charts for frequencies
      6m 34s
    2. Creating clustered bar charts for means
      3m 45s
    3. Creating scatterplots by group
      4m 13s
    4. Creating 3-D scatterplots
      4m 25s
    5. Creating scatterplot matrices
      5m 33s
  11. 30m 57s
    1. Using Automatic Linear Models
      11m 52s
    2. Calculating multiple regression
      9m 3s
    3. Comparing means with a two-factor ANOVA
      10m 2s
  12. 29m 29s
    1. Formatting descriptive statistics
      6m 1s
    2. Formatting correlations
      7m 49s
    3. Formatting regression
      10m 19s
    4. Exporting charts and tables
      5m 20s
  13. 51s
    1. What's next
      51s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Join now "Already a member? Log in

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed SPSS Statistics Essential Training (2011).

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.