Avatar of inforr
inforr
 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).

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

Thanks.
Microsoft Excel

Avatar of undefined
Last Comment
inforr

8/22/2022 - Mon
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
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
inforr

ASKER
Perfect - thank you!