Creating Compelling Charts in Microsoft Office 2010

In versions of Microsoft Office before Microsoft Office 2007, Microsoft Graph was used for creating charts; in Microsoft Office 2007 and Microsoft Office 2010, Microsoft Excel is used for embedding and displaying charts.

To insert a chart from within Microsoft Excel:

  1. Select the data and labels from which you wish to create your chart.
  2. Click Insert.
  3. In the Charts group, click a chart button, then click on your required type. Alternatively, click the Charts Dialog Box Launcher at the bottom right of the group, and the Insert Chart dialog box will be displayed.
  4. Click on a category in the left pane, click a chart, then click OK. A chart will appear embedded in the worksheet.

Note The easiest way to create a default column chart on a new worksheet is still to select the data and labels, then press the F11 key.

Changing chart location

To change the location:

  1. Click the Chart Tools Design tab.
  2. In the Location group, click Move Chart.
  3. To send the chart to a new sheet on its own, select New Sheet, or to send the chart to a different worksheet, select Object in and find the relevant sheet from the dropdown.

Changing chart type

To change type:

  1. Select the chart whose design you want to change.
  2. Click the Chart Tools Design tab.
  3. In the Type group, click Change Chart Type.
  4. Select your required chart type.
  5. Click OK.

Changing chart layout

To change layout:

  1. Select the chart whose layout you want to change.
  2. Click the Chart Tools Design tab.
  3. In the Chart Layouts group, select a layout or click the scroll up or down arrow to see further layouts, or click the More list arrow, then click your required layout.

Changing chart style

To change style:

  1. Select the chart whose layout you want to change.
  2. Click the Chart Tools Design tab.
  3. In the Chart Styles group, select a style or click the scroll up or down arrow to see further styles, or click the More list arrow, then click your required style.
  4. To send the chart to a new chart sheet, select New Sheet, or to send the chart to a different worksheet, select Object in and find the relevant sheet from the dropdown.

Changing chart titles

  1. Select the chart whose title you want to change.
  2. Click the Chart Tools Layout tab.
  3. In the Labels group, click Chart Title.
  4. Select one of:

  • None – This hides the title
  • Centered Overlay Title – Inserts a title on the chart without resizing it
  • Above Chart – Positions the title at the top of the chart and resizes it.
  • More Title Options – Sets custom chart options.

Double-click the text box, then type in the required title. Changing chart legend

  1. Select the chart whose legend you want to change.
  2. Click the Chart Tools Layout tab.
  3. In the Labels group, click Legend.
  4. Choose from the available options as to how you want your legend to be displayed.

Editing chart data

If you change data that is used, the chart will automatically be updated.

To add data to an existing chart:

  1. Select the chart to which data is to be added.
  2. Click the Chart Tools Design tab, then in the Data group, click Select Data. The Select Data Source dialog box will be displayed.
  3. To change the chart data, click the Collapse button at the right of the Chart Data Range box.
  4. To switch rows to columns and columns to rows, click Switch Row/Column.
  5. To add a new data series, click Add. Type in the name of the series in the Series Name box, or select the series name in the worksheet. In the Series values box, type in the range containing the values for the new series, or select the range in the worksheet. Click OK.
  6. To edit an existing data range, click Edit under Legend Entries (Series). Edit data as required. Click OK.
  7. To remove a data series, click on the series name, then click Remove. To reorder the data series on the chart, select the series to be moved, then click the Move Up or Move Down buttons to move to the required position.

Dragging data to a chart

  • If the chart is embedded, data can be also added to it by dragging the sizing handles of source data ranges. The data needs to be in cells that are adjacent to the existing worksheet data. Click on the chart so that the sizing handles around the source data on the worksheet is displayed.
  • To add new categories and data series to the chart, drag a blue sizing handle to include the new data and labels in the rectangle.
  • If you only want to add a data series, drag a green sizing handle to include the relevant data and labels into the rectangle.
  • If you want to add categories and data points, drag a purple sizing handle to include the new data and categories to the rectangle.

Copying data to a chart from a worksheet

To copy data to an existing chart:

  1. Select the worksheet data to be added to the chart.
  2. On the Home tab, in the Clipboard group, click Copy.
  3. Click on the chart.
  4. On the Home tab, in the Clipboard group, click Paste. Alternatively, if you need to specify exactly how the data should be copied to the chart, click the Paste button dropdown arrow and select Paste Special. Select your required options, then click OK.

Removing chart data

Assuming that your calculation options are set to automatic, if data is deleted from your worksheet, it will also be removed from your chart.

To remove a data series from a chart without affecting the source data:

  1. Click in the chart.
  2. Select the data series to be removed by clicking on it within the chart.
  3. Press the Delete key.

Creating charts in Word and PowerPoint

To create a chart in Word or PowerPoint:

  1. On the Insert tab, in the Illustrations group, click Chart.
  2. Select the required chart type from the Insert Chart dialog box, then click OK. The applications will tile, with Excel being opened at one side showing sample data, and a sample chart is inserted into Word/ PowerPoint.
  3. Type in your required data, overwriting the sample data. If you want to use data from a Word table you will need to copy the table to Excel, again overwriting the sample data.
  4. The chart will be created. Close Excel and the application will return to full size with the Excel spreadsheet embedded within them.

Note If you are working in compatibility mode, your chart will be created as it was in earlier versions of Microsoft Office.

Copying an Excel chart into Word/ PowerPoint

  • To copy a chart from Excel and paste it into Word/PowerPoint, select it within Excel, then from the Home tab, in the Clipboard group, click Copy (or press Ctrl + C). In Word/PowerPoint, place the insertion point where you want it to be pasted, then from the Home tab, in the Clipboard group, click the Paste dropdown. You will see various Paste Options allowing you to select how the chart should be pasted into your document.
  • If you want the chart to be linked to your Excel data set, so that if the Excel data changes, the chart also changes, ensure that one of the Link options is chosen.
  • If you want to paste as a picture, so you can easily resize it, etc, but will not be able to edit the data, click Picture (the last of the five options shown here.).
  • To paste in its Excel format, click Keep Source Formatting & Embed Workbook.
  • To paste and format it using the document theme applied to the document, click Use Destination Theme & Embed Workbook.

Note If you copy a chart to a document that is open in compatibility mode into Word, these options are not available and it will be pasted as a static picture.

Astrolgical Solar Chart and Importance of Transiting Planets


Transits in Houses

The Solar Chart has great value, both to the client and the student. One of the major problems with the Natal Chart is timing. Not everybody knows the exact time of their birth. Thus, there may be erroneous placements of Planets in Houses and a BIG discrepancy with the rising signs.

No such problem exists with the solar chart. Most people know the DAY they were born.

A competent Astrologer can impart good useful knowledge to their clients and students through their Solar Charts.

Let us look and see where the Transiting Planets are at the the day of this writing and see how to place them in a Solar Chart. Today is the first day that the Sun enters the Sign of Pisces. It will remain there for 30 days. Each month the Astrologer will have to update the information he passes on to his client and student as the Sun rotates into a new sign.

This article can be used as a general outline or template for the placement of all transiting Planets in the Solar Chart.

Today we have:

Sun in Pisces

Jupiter in Capricorn

Saturn in Virgo

Uranus in Pisces

Neptune in Aquarius

Pluto in Capricorn

For the full scope of this article I will need to place these Transiting Planets in twelve separate Solar Charts. There will be one for each of the signs Aries, Taurus, Gemini, etc. By doing this I will know not only place the Transiting Planets in their respective signs, but also what Houses they occupy.

I will work out one Solar Chart and leave the rest to the reader. There is sufficient information here for you to do so. If you need help you may contact me by e-mail.

For a Sagittarian Solar Chart I have:

Sun in Pisces in 4th House

Jupiter in Capricorn in 2nd House

Saturn in Virgo in 10th House

Uranus in Pisces in 4th House

Neptune in Aquarius in 3rd House

Pluto in Capricorn in 2nd House

The major aspects formed by these six planets are:

Sun Conjunct Uranus

Jupiter Conjunct Pluto

Sun Sextile Jupiter

Sun Sextile Pluto

Uranus Sextile Jupiter

Uranus Sextile Pluto

Sun Opposition Saturn

Saturn Opposition Sun

Jupiter Trine Saturn

Saturn Trine Pluto

You can see the wealth of information that can be garnered from a Solar Chart.

The simplified reading I would give a client and student would be this:
The main areas of interest and energy is your 2nd and 4th Houses. The main areas in your life which will be affected are your means of making money and your home and family.

We have the Sun in Pisces in the 4th House, so the Power will be turned on your home,family and mother. Look to these areas of interest to you at this time.

Sun Conjunct Uranus in 4th House and 10th Houses, home and career. Will make you aware of your limitations in these areas. You will need to make compromises between the two Houses.

Sun Sextile Pluto, 2nd and 4th House, money and home. There will be opportunities for changes and deep thinking about future.

Sun Sextile Jupiter, 2nd and 4th House, money and home. This is a very lucky time for you.

Jupiter Conjunct Pluto 2nd House of money. You will have a deep desire to be successful and attain power.

Jupiter Sextile Uranus, 2nd and 4th House, money and family. These are exciting mental times and a good chance for financial gains.

Saturn Opposition Uranus, 4th and 10th Houses, home and Career. It is time to readjust your dull job, marriage or relationships.

Enough for this example. More articles to follow.

You can see how much information you can impart to your client and student from a well constructed Solar Chart. And there is no need to worry about if the time of birth is correct.

Will the Current Recession Change the Design of New Homes? Past Recessions May Give Us a Clue!

For those of you returning to your childhood home over the holidays, you might have noticed how much houses have changed over the years. Lifestyle trends, building product technologies and economic fluctuations have all had a hand in changing the American home. How will the current economic outlook affect the homes of tomorrow? If the current recessionary period is anything like those from the past, you may be surprised. Building a new home can take many months to design and build. Successful home builders use all of their powers of perception to design a home today that will sell in the housing market tomorrow. As witnessed by current events, rapidly changing demographic and economic forces can play havoc on those future markets catching many home builders off guard with homes “that don’t sell”. These changing forces sometimes alter the design of homes – for better or worse. Over the past thirty five years, economists generally recognize five economic recessions or crisis:

  • The 1973 oil embargo
  • The recession of the early 1980’s
  • The recession of the early 1990’s
  • The recession of the early 2000’s
  • The current recession that started in 2007

Each of these events had short and long term influences over the way homes are designed and built. Understanding these trends, home builders may be better able to predict the needs and demands of the future housing market. We plotted U.S. Census data for new housing activity over the past 35 years. From this data, we developed eight different charts that shows how the economic recessions of this period affected the design and style of new homes. Charts, corresponding to each item below, may be accessed by clicking on the link at the end of the list.

  1. Size matters – If you think the latest recession will lead to smaller homes, think again. Historical statistics show that past recessions have merely slowed the trend for larger and larger homes. With the exception of a slight decline in the late 1970’s, home sizes have steadily increased. The average home today is fifty percent larger than one built 25 years ago.
  2. Sleeping Conditions – The recession of the early 1980’s seems to be the only influence on the number of bedrooms in newly constructed homes. But, by the end of the 1980’s that effect was corrected and a general trend toward homes with four or more bedrooms continues to this day.
  3. More Facilities – The events of the early 1980’s had influence on the number of bathrooms in new homes, too. A trend of building more homes with only 1 full bathroom was quickly reversed by the end of the economic challenges. Prior to 1985, data for homes with three or more bathrooms is not available. But, like bedroom allocations, a continued trend toward more bathrooms has continued for almost twenty years.
  4. More Parking – The early eighties also affected the type of garage designed into new homes. The number of homes built with no garages increased to the detriment of homes with two car garages. But that trend quickly revered after the negative economic affects subsided. For the past fifteen years, almost two thirds of all new homes built have two car garages.
  5. Up, not out! – As the size of new homes steadily increased over the past 35 years, so too has the number of multiple storied construction. Again, the eighties recession seems to have the most effect, but for the last fifteen years the market is almost evenly split between single and multiple story homes with a slight deviation occurring since 2001. Even with a retiring baby-boom generation, the number of homes built on one floor seems to be counter intuitive.
  6. Burn, baby burn! – The energy crisis of the early 1970’s seems to have the most affect on the inclusion of a fireplace in newly constructed homes. Were we intending to burn our fireplaces instead of our furnaces? Maybe so, but the recession of the early 1980’s reversed this trend and today the market is almost evenly split between homes with and without fireplaces. Even with the housing booms in warmer climates, we continue to want the warmth and glow of a fire.
  7. The magic of heat pumps – Heat pumps were introduced to new homes in the mid-1970’s. Because of the oil crisis of the early 1970’s, heat pumps were accepted quickly as a more efficient way to heat a home. So much so, in 1978 the U.S. Census created a new category to track heat pump installation. Since then, heat pump installations have remained relatively steady as their effectiveness has been questioned in many regions. In recent years, new advances in heat pump technology have resulted in increased market share. Will that trend continue? Possibly, but for more than a quarter of a century, warm-air furnaces have been the heat system of choice for the American home. Even after the 1973 oil crisis, solar, wind and geothermal technologies have continued on a disappointing trend of gaining little market share. Let’s hope that trend changes soon.
  8. The Way We Look – External siding had considerable changes over the past 35 years. Maintenance free vinyl siding took tremendous market share from an industry dominated by wood. It should be no surprise that low cost, easily installed, low maintenance building products are quickly accepted. Quickly in the building industry is a relative term as it took 20 years for vinyl siding to become the market leader (prior to 1992, vinyl siding sales were included in the “Other” category). Again the economic recession of the early 1980’s seemed to affect the market most. Out of this recession new products and technologies were introduced to meet unfulfilled needs in the market. Primarily, vinyl siding products began to take market share from all of the other categories dominating the market in the early years of the new millennium. Recently, that domination is threatened by the introduction of fiber cement siding in the last part of the 1990’s. Will that trend continue or will there other technologies emerging from this recession that will dominate future markets?

What’s Up With That?

So what does all this mean? Taking a line from our fractured financial system, we would like to declare that “past performances do not guarantee future results”. But if history teaches us anything, the history of American recessions of the last 35 years will probably not have much effect on housing styles and designs. Monetary and financial pressures of past economic challenges seem to have little lasting effect on the houses we want to live in.

But there are more factors that influence house design. The aging population, changing industries, immigration and emerging social trends all can change the kind of homes we build. These and hundreds of other natural and man-made issues will continue to contribute to the design and style of the American dream. Assuming that a serious economic downturn is going to drastically affect home design is just not true. The forces that change home design have been in the market for years and will continue to influence home design despite the economy. The economy may slow a trend or temporarily change its direction, but empirical data shows that a trend is a trend and will continue on its path despite the economy.

So where are we going?

The three home characteristics – square footage, number of bedrooms and number of bathrooms – won’t change drastically. In fact, we think the average home size will continue to increase, more four bedroom homes will be built and these homes will have even more bathrooms. But the reason for this will not be to satisfy ego alone (although that will continue to influence the market). An aging population combined with improved health care means people live longer. Challenging economic conditions means that they may not have the money to do it.

House sizes will continue to grow because they need to support more people. Facilities for aging parents moving in with their children will be part of the new home design. More bedrooms, more bathrooms and even more fireplaces will be built for more people. Separate, self sustained living quarters with separate entrances will be built all under one roof. The lines on the graphs will continue to increase – for reasons already in the market – while floor plans for those designs will satisfy new market demands.

Technology will play a large part of the new home design. New product developments spurred from stricter building codes, energy codes and manufacturer differentiation will allow larger homes to be built for less. Home designs will have to incorporate plugs and power sources for electric cars. Water collection and recycling along with solar panels and geothermal energy will be included in future designs as will improved home monitoring and control. “Smart” windows and doors and even “smart” walls and roofs will all maximize energy performance, minimize operating costs and help Americans keep their American dream alive.

The future house will be bigger, better, more efficient with wider hallways, fewer stairs and a place for more than just the immediate family. It will be re-purposed to accommodate the lifestyle changes of a diverse population. The death of the dining room is finally a reality while larger, more versatile eating areas designed as part of the kitchen facilities will be in demand. Outdoor and even “semi-outdoor” areas will become more sophisticated. Studies, computer nooks and entertainment rooms will replace dining rooms, family rooms and dens as homes become more functional dwellings for occupants of all ages. Room sizes, floor plans and integrated functionality will be significant changes. But despite economic doom and gloom reports, homes will continue to get bigger because the more we ask for change, the more we really just want more – much more – of the same.