Combo Chart-Line and Column

J

JVILA

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.
 
L

Lucy Thomson (aka aneasiertomorrow)

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
 
A

Andy Pope

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
 

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