+ Reply to Thread
Results 1 to 2 of 2

combining different excel charts

  1. #1
    Registered User
    Join Date
    06-12-2006
    Posts
    1

    combining different excel charts

    Hi,

    I have an economic time series that I've graphed using a line chart. Our professor wants us to add recessions to this chart. Is there a way adding a bar chart to a line chart?

    I just drew vertical lines between the dates in question and added diagonals but the graph looks amateurish. Ideally, I'd like to be able to add a shaded column between the dates but still have the line show through the shaded area.

    Thanks.

    Bob

  2. #2
    Andy Pope
    Guest

    Re: combining different excel charts

    Hi,

    Have a look at Jon Peltier's example of vertical banding,
    http://peltiertech.com/Excel/Charts/...ticalBand.html

    Cheers
    Andy

    rkizik wrote:
    > Hi,
    >
    > I have an economic time series that I've graphed using a line chart.
    > Our professor wants us to add recessions to this chart. Is there a way
    > adding a bar chart to a line chart?
    >
    > I just drew vertical lines between the dates in question and added
    > diagonals but the graph looks amateurish. Ideally, I'd like to be able
    > to add a shaded column between the dates but still have the line show
    > through the shaded area.
    >
    > Thanks.
    >
    > Bob
    >
    >


    --

    Andy Pope, Microsoft MVP - Excel
    http://www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1