Microsoft Graph displays data incorrectly - two chart types

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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?
Click to expand...
Click to expand...
 
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top