graphing issue

[jw01]

Hello

I have a simple line graph but having some trouble trying to show "headcount" on the graph.

I have two sets of data (reported revenue) that Im showing, however, I would like to show the respective headcount .

when i select "show data labels, it shows me the values $ values, but i would like to replace that and show headcount that make up that revenue?

i have attached a sample, can someone pls help me with the obvious, thx you!

in my attachment, i have tried showing it thru a "txtbox"

[ChemistB]

I'm not sure how you want the graph to look. Attached, I added the Headcount data as a separate series and then changed the chart type for that series only to Column. Would this work for you?

[jw01]

hey bud

thxs for the concept!

i took ur idea, and basically cleared out the bar graph, and left the headcount in the "graph table"

so pretty much cleared out or unfilled the bar graph, thxs alot!