Create Bar Graph in Excel 2007

baleman2
baleman2 used Ask the Experts™
on
I'm viewed the tutorials and all seems easy enough.  However, all my data is not displaying as expected.  Not sure if it's related to some "subscript" entries in the Chemical equation names or what.
I need the chemical equation compounds at the bottom on the x axis and the volumes to display on the left on the y axis.
Even though I highlight all the data shown in the spreadsheet, the bar graph I create displays only the compound in Cell A7 and none of the volumes are displayed.
Chem_Graph.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Have added a hand drawn graph of what I expected to be able to accomplish.
Hand-Drawn-Graph-of-Data.pdf
Commented:
Column B (containing numbers of millileters) should not have had the letters "ml" after the number itself.  After those letters were removed, graph appeared correctly.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial