Results 1 to 6 of 6
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    link PPT chart to Excel (PPT 2003)

    I don't use PPT much at all but I do know Excel fairly well. I need help on taking a chart that was made in PPT and export (link) it to Excel such that whenever I want to change the chart, I can go to the data table that's in Excel. How can that be done?

    I managed to copy the chart's data table to Excel and can make a chart in Excel but the chart is 90degrees off (the x and y axis are flipped such that what's vertical in PPT is horizontal in Excel. I don't know how this chart was originally created (in PPT or Excel). I attached a pix of the chart as it appears in PPT.

    I was able to copy/paste special (as link) back to PPT, but I still have the flipped axis problem.

    What am I missing here (besides common sense <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15> )

    Thnx, Deb

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: link PPT chart to Excel (PPT 2003)

    What happens if you select the chart in Excel and click the By Rows/By Columns button on the Chart toolbar, or equivalently, if you select Chart | Source Data... and click Rows or Columns (whichever one is not selected now)?

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: link PPT chart to Excel (PPT 2003)

    More info.. I discovered that this chart is a custom type in PPT (I don't know how they made this). I can create the chart in Excel but the xy axis are rotated. I couldn't figure out how to filp them as you said since the "by rows/cols" wasn't available. Attached is my scratch pad Excel sheet where I have the original data, a pix of the PPT chart and two chart attempts by me. The bottom chart (gray) uses a copy of the PPT data table (most of which isn't needed to do the chart at all).

    Thnx,
    Deb

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: link PPT chart to Excel (PPT 2003)

    I'm sure Steve (sdckapr) will be able to help. I'll move this question to the Excel forum. It's not really a PowerPoint question, after all.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: link PPT chart to Excel (PPT 2003)

    How is this?

    I created the XY chart directly from the data and changed the markers and lines to match. Move the legend and removed the Y-axis.

    I then added the range from U2:Y4 as new ranges (and removed the listing in the legend). I moved them all to the secondary axis and changed the chart types to "Stacked area" U1:Y1 is the heights for each area.

    I added Text boxes for the Low, High, and the "Title".

    Steve

  6. #6
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: link PPT chart to Excel (PPT 2003)

    WOW that' great. I obviously didn't think of doing an area chart and 2nd axis; I was using the wrong chart type. This will help a lot!! Thank you very much.

    Deb <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

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