Large Chart / Graph Issue

[cc143most]

I have a large bar chart in my report with so much information that not all of my horizontal labels are printing. Is there a way to split the chart so that it prints in two sections like you can in Excel?



Thank you for any help!

[June7]

How do you do that in Excel?

I think in Access that would require two chart objects, each with different filter criteria to pull different set of records.

[cc143most]

In Excel, you can "stretch" the chart until all of the labels are visible; it will then print on two separate pages. I think my friend is doing something fancier to get these 3 big charts out, but I'm not sure what. I have emailed her to ask the steps in Excel.

[June7]

Never tried with a graph but I think the 'stretching' could also work on Access report. At least up to 22 inches which is the maximum width (and length) a report can be designed.

[cc143most]

Stretching did work, but you have no control of where it splits the chart and it looks sloppy. In Excel, you manually highlight the data you want charted, so two separate charts can be easily created (effectively splitting your data into two parts).

I had not thought that adding criteria to my RowSource for the chart was, in effect, creating a separate query. I added that the Staff_Name had to start with A-K for my first graph and L-Z for the second and they are beautiful!! More importantly, it didn't affect any of my data below the graph!

Thank you, again, June7 for pointing me in the right direction!