Creating a Bar Graph with a reference point

[Swalker]

Hey guys,

I would like to create a Bar Chart/Graph (horizontal) that would have
two sets of values and one category group. I would like to display
this as followed: value set 1 to be a bar and the value set 2 to be a
reference dot for value set 1. Say my Data looks like the following:

CatergoryGroup Val1 Val2
Month1 1 4
Month2 2 3
Month3 7 5

Again, I want Val1 to be bars. Val 2 I want to be dots on the same
graph.

I looked at the Column Charts and there is the "Plot Data as Line" I
do not want this for many reasons.

Any help is appreicated.

 

[Duane Hookom]

You should be able to set the Line format to None and only display the Markers.