Microsoft Graph displays data incorrectly - two chart types

G

Guest

Hi,
I have a combination chart inserted into a powerpoint slide that shows
budget numbers for 2003-2007 and actual data for the same time period by
month. I want the Budget numbers to graph as a line and the actual data to
graph in columns. Everything is find for the year 2003-2006 but for some
reason the data for 2007 is charting as a line. I have tried everything to
fix it-changing Chart type, deleting and reentering the data, even tried to
recreate in a brand new chart. Any suggestions on how I can change this 2007
data to chart the same as the previous years?
 
G

Guest

No, it is not a separate series. At least I don't want it to be. Is there
anything that should be checked or make sure it isn't being plotted as a
separate series?

Echo S said:
Is that data a separate series? If so, make sure it's been added to the
other "actual data" data series.

--
Echo S [MS PPT MVP] http://www.echosvoice.com
What's new in PowerPoint 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/index.html
PPTLive! Oct 28-31, New Orleans http://www.pptlive.com

Carla said:
Hi,
I have a combination chart inserted into a powerpoint slide that shows
budget numbers for 2003-2007 and actual data for the same time period by
month. I want the Budget numbers to graph as a line and the actual data
to
graph in columns. Everything is find for the year 2003-2006 but for some
reason the data for 2007 is charting as a line. I have tried everything
to
fix it-changing Chart type, deleting and reentering the data, even tried
to
recreate in a brand new chart. Any suggestions on how I can change this
2007
data to chart the same as the previous years?
 
E

Echo S

If it's in a different row in the data sheet, it's a separate series.

--
Echo S [MS PPT MVP] http://www.echosvoice.com
What's new in PowerPoint 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/index.html
PPTLive! Oct 28-31, New Orleans http://www.pptlive.com

Carla said:
No, it is not a separate series. At least I don't want it to be. Is
there
anything that should be checked or make sure it isn't being plotted as a
separate series?

Echo S said:
Is that data a separate series? If so, make sure it's been added to the
other "actual data" data series.

--
Echo S [MS PPT MVP] http://www.echosvoice.com
What's new in PowerPoint 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/index.html
PPTLive! Oct 28-31, New Orleans http://www.pptlive.com

Carla said:
Hi,
I have a combination chart inserted into a powerpoint slide that shows
budget numbers for 2003-2007 and actual data for the same time period
by
month. I want the Budget numbers to graph as a line and the actual
data
to
graph in columns. Everything is find for the year 2003-2006 but for
some
reason the data for 2007 is charting as a line. I have tried
everything
to
fix it-changing Chart type, deleting and reentering the data, even
tried
to
recreate in a brand new chart. Any suggestions on how I can change
this
2007
data to chart the same as the previous years?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top