swfrontier
New Member
- Joined
- Jan 18, 2005
- Messages
- 2
Trying to create a graph showing each monthly sales total with labor and materials percentage to sales. How can I create a formula to do this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Graph Showing Labor & Materials Percentages to Sales????
- Thread starter swfrontier
- Start date
Trying to create a graph showing each monthly sales total with labor and materials percentage to sales. How can I create a formula to do this?
Excel Facts
Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Re: Graph Showing Labor & Materials Percentages to Sales
Divide the labour and materials by the sales, format as percent and plot that.
Divide the labour and materials by the sales, format as percent and plot that.
Upvote
0
swfrontier
New Member
- Joined
- Jan 18, 2005
- Messages
- 2
Re: Graph Showing Labor & Materials Percentages to Sales
Thanks for the quick reply. What kind of chart are you referring to? Needs to be a chart that can be easily understood.
Thanks for the quick reply. What kind of chart are you referring to? Needs to be a chart that can be easily understood.
Upvote
0
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Re: Graph Showing Labor & Materials Percentages to Sales
Line or Column should do it, with the months on the x axis.
Line or Column should do it, with the months on the x axis.
Upvote
0
Similar threads
