Ok guys,
I finally figured out how to get all my data into one pivot table and create A chart exactly how I envisioned. Unfortunatley the Y values for the various pieces of data are drastically different. For example, I am trying To compare data which ranges between ~0 to ~100 to data points which fall ~500000. This Zooms out the graph to the degree that the smaller data can not be discerned.
\1
vs.
\1
I believe my two options are having two identical charts on the same worksheet in order to compare, or some how zoom the Y-axis on the points I am trying to compare.
Remember, this is a pivot Chart, So I dont think Im allowed to touch the source code.
How would I do either of the above? I am of course open to suggestions if anyone believes there is a better way to do it.
Thanks In advance!
Bookmarks