You haven't told us what software you have and what version.
InDesign is not designed for creating charts. A much better choice is Adobe Illustrator using the Graph tool:
If you have Illustrator 2015 you could try a technology preview called Creative Cloud Charts. It's still in development and not very completely developed so it might not meet your needs. Its called a "technology preview."