ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software»
  • Computer Software

Creating charts and graphs in Excel 2007

Updated on August 22, 2012

Using Excel 2007 to create graphs to display and summarise your data in a pictorial format is a popular and integral part of Excel. Excel 2007 changed the way graphs are created when compared to previous versions of Excel. The whole interface in Excel 2007 changed significantly from the menus seen in Excel 2003 and previous versions with the introduction of the ribbon. This hub was created as part of my learning process in adjusting from Excel 2003 to Excel 2007 and is a guide on the creation of graphs using Excel 2007.

Configuring your data before creating a chart or graph

Excel 2007 is far more precise when it comes to how it wants the data to be formatted before the graph it creates from your data will look as you would expect it to look. By way of example, I am trying to create a pie chart showing how may farm animals my farm has. I have reversed the columns to illustrate the difference in the graphs created by Excel. Of course, I can adjust the graph so that it displays correctly, but creating the data in a format Excel likes is much more straightforward.

As you can see from my example, the top chart looks some way towards what you would expect and the bottom chart is a disaster. Excel clearly prefers the labels on the left and the data on the right!

Creating a chart or graph

To create a graph or chart once you have your data formatted correctly is very simple. Select your data and then click on the Insert tab and select the type of graph you wish to use. You will immediately notice that the chart wizard from Excel 2003 was a casualty of the upgrade to 2007 which is a great pity. Excel 2007 has the common graph types as buttons on this tab. Column, Line, Pie, Bar, Area, Scatter and Other charts all have their own buttons. Selecting the Column button for example gives you all the sub-categories of column graphs and at the very bottom, you can select from all chart types.

Configuring your graph

Once you have selected and chosen your chart or graph type (I chose a pie chart) Excel will create your chart and also create three new tabs just for charts Design, Layout and Format.

Design tab

On the Design tab, you are able to select from a large number of Chart Styles and Chart Layouts to further customise the look of your graph.

To change the data displayed in your chart of graph, select the Select Data button on the Design tab. You can also change the chart type, save the chart or graph as a template and move the graph all on the Design tab.

Layout tab

The layout tab has a number of very useful functions available to further polish your chart and also add many elements that may be missing such as a title or other labels depending on the style and layout you have chosen while in the design phase of graph or chart creation

Excel has a very useful tool on the left hand end of the Layout tab. You will see from my example below that mine is currently set to Legend. If I were to use the drop down and select Series 1 Data Labels then I would be able to edit or move those labels so that they were positioned exactly where I wanted them and in the font and size I desire as well.

As you can see from the Layout tab, you can add, move and also configure text boxes, titles, legends as well as configuring the axes, adding removing gridlines. As mine is a pie chart, many of those options are not available, but should I decide to change it to a bar chart for example (via the option on the Design tab), some of those greyed out options become selectable.

Format tab

The format tab allows you to format the text in a number of funky ways adding glow effects, shadows or even reflections to the text used in your graph. You can also precisely resize your graph using inches, should you need to have your graphs sized exactly (particularly useful if you require a number of graphs that look identical in their formatting.

Changing data for your graph

As I mentioned above, Excel is very particular about the data being correctly formatted in order for it to be able to create meaningful graphs. If your data is not formatted exactly as Excel wants it and you have too much data to reformat (or you simply don’t want to for whatever reason) never fear. Simply create the graph and then click on the Design tab and choose the Select Data button. It is important to understand exactly what Excel is looking for as often what is in there to begin with will cause Excel to error or produce an even stranger graph.

For my example, the data goes on the Left (Legend Series) and the Horizontal (Category) Axis Labels go on the right. You can see that my range is

=Sheet1!$D$11:$D$14. Excel will accept this as a range and my graph will now look as I want it to.

Conclusion

Creating graphs or charts in Excel 2007 despite the lack of the wizard is still relatively straightforward with a wide range of styles and layouts only a click away. It is very easy to create some striking and even funky graphs using the text formatting and 3D graph styles available now in Excel 2007. The only thing to watch is your data formatting which can sometimes make graphs tricky to create. Once you are aware of this, creating graphs is as easy as it was in previous versions of Excel. I do hope that you have enjoyed reading this hub and have found it useful. Please feel free to leave any comments or suggestions you may have below. Thanks for reading!

I also have a number of other hubs on aspects of Excel 2007, covering everything from Conditional Formatting to creating charts and graphs. I have an Index hub which also covers how I successfully transitioned from Excel 2003 to 2007 as well as outlining my other Excel 2007 hubs which can be found here

http://robbiecwilson.hubpages.com/hub/How-to-adjust-to-Excel-2007-from-previous-versions-as-well-as-step-by-step-guides-to-many-functions-in-Excel-2007


Comments

    0 of 8192 characters used
    Post Comment

    No comments yet.

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: "https://hubpages.com/privacy-policy#gdpr"

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)