Is it possible to recreate this excel chart in PowerPoint?

[Guest]

<a href="http://photobucket.com" target="_blank"><img
src="http://i24.photobucket.com/albums/c30/gennygogo/Picture2.jpg" border="0"
alt="Photobucket - Video and Image Hosting"></a>

 

[Michael Koerner]

Use the Insert, Object, select Excel Chart, then select either Create from
file or Create new.


--
<>Please post all follow-up questions/replies to the newsgroup<>
<><>Email unless specifically requested will not be opened<><>
<><><>Do Provide The Version Of PowerPoint You Are Using<><><>
<><><>Do Not Post Attachments In This Newsgroup<><><>
Michael Koerner [MS PPT MVP]


| <a href="http://photobucket.com" target="_blank"><img
| src="http://i24.photobucket.com/albums/c30/gennygogo/Picture2.jpg"
border="0"
| alt="Photobucket - Video and Image Hosting"></a>

 

[Echo S]

<a href="http://photobucket.com" target="_blank"><img
src="http://i24.photobucket.com/albums/c30/gennygogo/Picture2.jpg"
border="0"
alt="Photobucket - Video and Image Hosting"></a>

PPT doesn't do individual error bars, which are how the confidence intervals
(or whatever those are -- maybe standard deviation?) on this chart were
probably created.

In PPT, you might be able to do it in a hi-low stock chart and then rotate
the chart, but it would be tedious, and you might have issues with the text
rotation.

All in all, Excel is the best tool for this chart. It would be very hard to
do -- I'd say close to impossible -- in PPT's MS Graph. Of course, you could
always do the line graph in PPT and then draw the error bars manually. (But
ewwww, *not* the way I'd want to do it!)

 

[Andy Pope]

Sorry Echo, I could not resist the challenge

The example is built using xy scatter series.
http://www.andypope.info/ngs/ng51.htm

Although it is possible in msgraph the suggestions to use excel are much
more sensible. Especially if you need to calculate the +/- values for
your error bars.

Cheers
Andy

 

[Guest]

Wow! Thanks!!

Sorry Echo, I could not resist the challenge

The example is built using xy scatter series.
http://www.andypope.info/ngs/ng51.htm

Although it is possible in msgraph the suggestions to use excel are much
more sensible. Especially if you need to calculate the +/- values for
your error bars.

Cheers
Andy

 

[Echo S]

Sorry Echo, I could not resist the challenge

The example is built using xy scatter series.
http://www.andypope.info/ngs/ng51.htm

Although it is possible in msgraph the suggestions to use excel are much
more sensible. Especially if you need to calculate the +/- values for your
error bars.

OMG. Andy, that's amazing! (But when I look at the datasheet, it makes my
brain hurt!)

 

[Patrick Schmid]

WOW. Cool Chart Andy.
Here is an interesting observation: Open the file with ppt 2007 and edit
the data source. Guess what happens? It opens Excel. It also shows the
default PPT 2007 charting tabs suggesting that it internally upgraded
the MS Graph chart to a full-fledged Office 2007 chart.

Patrick Schmid

 

[Echo S]

Yeah, charting in PPT 2007 is a lot different under the hood. I'm glad to
hear 2007 is updating the 2003 charts properly.

--
Echo [MS PPT MVP] http://www.echosvoice.com
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com

WOW. Cool Chart Andy.
Here is an interesting observation: Open the file with ppt 2007 and edit
the data source. Guess what happens? It opens Excel. It also shows the
default PPT 2007 charting tabs suggesting that it internally upgraded the
MS Graph chart to a full-fledged Office 2007 chart.

Patrick Schmid
--------------
http://pschmid.net

Sorry Echo, I could not resist the challenge

The example is built using xy scatter series.
http://www.andypope.info/ngs/ng51.htm

Although it is possible in msgraph the suggestions to use excel are
much
more sensible. Especially if you need to calculate the +/- values for
your
error bars.

OMG. Andy, that's amazing! (But when I look at the datasheet, it makes my
brain hurt!)

--
Echo [MS PPT MVP] http://www.echosvoice.com
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com

 

[Andy Pope]

Thanks, glad you all like it.

The 2007 conversion worked for me, which was nice. But once it became a
2007 chart it started to mis behave.

Also I had a look at the data store in excel and because I didn't close
excel in the correct way the next time I opened the ppt file it remained
a msgraph.

I think I maybe able to use this example to report a few more bugs!

Cheers
Andy