Newbie - unsure of what I can do w/Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is my situation - the data that I am attempting to chart is a
combination of numbers and y/n which are answers to questions about usage:

Example:

Location: Apple
Task To Be Done (Y/N): Y
Task Should Be Done(Y/N): Y
Quantity Done (#): 12
Quantity Not Done (#): 4

There are 13 locations

Each location has 2 resources

Ultimately, I am trying to show value added using current resources.
However, I am stuck. Can anyone help?

Thank you.
 
You have left out more than you've supplied. How are you defining,
measuring, and calculating "value"? What parameters do you want to
correlate with "value"? Presumably value will be plotted along the Y
axis (i.e., so higher in the chart means greater value); will this be a
column chart with one column per location? If you think about how an
informative chart might look, it might help you decide how your data
needs to be configured.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top