Need to show multiple bar graph values by month/year as well as category. Also need to show a line within the bar graph that represents the goal for each bar. Tried a combination graph, but we have 2 “On change of” items (month/year & category) so it will not allow a second “Show value” item. Also tried laying a transparent line graph on top of the original bar graph, but can’t get all of the dimensions of the graph to line up correctly. Where it is correct for one page, it is over or under on the next page.
Any advice would be greatly appreciated.
I am using the CR2008