We purchased this software for that particular purpose, but it does not appear to be an option. Can anyone help on this?
You might be better off with Illustrator.
Photoshop is first and foremost a photo editing application. Sure you can do other things with it these days—painting, 3D work, basic video editing—but I wouldn't put charts on that list.
illustrator is better than Photoshop, but Illustrator's charting functions haven't been updated in years and are very hard to work with. As long as I am willing to work slowly and methodically, I can create them, but it's a painful process. I'd say you would be better off with Excel, or a dedicated chart and graphs application. Here are a few, none from Adobe: