Forum Discussion
creating a graph with the same data for multiple companies
Have you tried using a Pivot Table to initially summarize the data, and then have a Pivot Graph developed directly from that Pivot Table?
I added a column for month to what is otherwise your table, and just quickly let Excel summarize the CAPE values in this attached Pivot Table and adjoining graph. Is this the kind of thing you're wanting to do?
thank youmathetes
I had not thought of this and it does work for one of the ratios/columns and I think I will have to go this route
but i still cant see multiple ID#s with the multiple ratios/columns over time - perhaps I need 3D ?
tina
The Pivot Table will work for many columns and many ID#s. I used just the ones you provided to illustrate, not to limit.
And one good thing, you can't break the data by playing around with the settings for the Pivot Table...
If you want more help, you'll need to upload a more complete sampling (or the full data set, so long as there's nothing confidential in it)....and I or someone else can show you a more complete example. It would also help if you can describe more fully the kind of graphing you want---i just let Excel pick the first graph that is supplied.....
