one table vs 100+ tables

I have about 100+ charts (each chart is a group of trendlines with data
points and labels for each point, and the x and y axis may vary between
charts) and I want to create a database from it with the capabilty to
1. search charts by category, title, x, y, etc. create a list of results,
and draw the chart when user click on one of the search result.
2. be able to expand, such as adding data to a chart or adding charts.

Is Access capable to handle it? If not, what other choise I have for a
simple cheap design? If Access is ok, I have the following question.

I'm trying to come up a design for creating charts out of tables. I have
two design ideas in mind, would you suggest me the better one, or come up a
new idea?
Idea A. all charts in one or a few tables with an extra field as chart name
pro: can use one function to draw all the charts
con: may have to add columns if future expansion requires

Idea B. one table for each chart, and use chart name as table name
pro: easy to maintain and update tables, and flexible to future expansion
con: not sure if one function can handle all the charts by table name?

the design is simpler the better, I plan to get it done in a few days (I
mean the archeture, not adding data) if possible.

thank you vey much in advance,

Wei