asked on

Excel Bullet Chart (XY Scatter Graph issue)

Hi,

I have been following this web page to create vertical and horizontal bullet charts . I have run into an issue when creating the horizontal version where by the orientation of the XY Scatter graph point remains horizontal instead of vertical (as shown below).

Does anyone know how to change the orientation of the XY Scatter graph point so it is vertical?

Thanks.

Saqib Husain

Can you upload a sample file?

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

Hello,

Charley Kyd's tutorial shows the step by step for the vertical bullet graph, which uses horizontal error bars for the target markers.

Since you are building a horizontal bullet graph, you need to use vertical error bars instead or horizontal ones. Just delete the horizontal error bars and format the vertical error bars in the same manner.

cheers, teylyn

inforr

ASKER

Hi Teylyn,

I know the article mentions error bars as part of the set up, no error bars are actually on. The article is not reflective of the features/dialogs in Excel 2010.

The marker is just a point on the chart so I'm not clear on your instructions to change the error bars.

Hi ssaqibh - I've uploaded a sample
Stephen-Few-Bullet.xlsx

ASKER CERTIFIED SOLUTION

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

inforr

ASKER

Perfect - thank you!