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"
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?
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks