Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / December 2007

Tip: Looking for answers? Try searching our database.

Combo Chart-Line and Column

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JVILA - 06 Dec 2007 01:26 GMT
I am trying to create "recession" bars by adding two series in line type and
converting the one that would indicate recession period to a "column."
However, I am getting only thin lines as opposed to a single column for each
economic recession period. I tried closing the gaps between the thin lines
hoping that they would overlap together, but I'm still getting thin lines. I
have been doing this with excel and never had any issues.

Thanks.
Lucy Thomson (aka aneasiertomorrow) - 06 Dec 2007 04:25 GMT
If I was you I would create the chart in excel & copy paste across (as a
picture to stop powerpoint including the whole workbook) and save the excel
in the same folder as the ppt in case I needed to make changes. But then I
never use MS Graph as it's rubbish :-)

Lucy
Signature

MOS Master Instructor
www.aneasiertomorrow.com.au

> I am trying to create "recession" bars by adding two series in line type and
> converting the one that would indicate recession period to a "column."
[quoted text clipped - 4 lines]
>
> Thanks.
Andy Pope - 06 Dec 2007 11:30 GMT
Hi,

The thin columns are caused by the axis being treated as dates.
Right click chart and pick Chart Options.
On the Axis tab set the Category (X) axis to Category

Cheers
Andy

Signature

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

>I am trying to create "recession" bars by adding two series in line type
>and
[quoted text clipped - 7 lines]
>
> Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.