Im trying to make a pivot chart that looks like this....what would be the basic structure of the table i would need to create it. Im very new and having issues getting it to look right.
Thanks!
10hr.jpg
Im trying to make a pivot chart that looks like this....what would be the basic structure of the table i would need to create it. Im very new and having issues getting it to look right.
Thanks!
10hr.jpg
It would depend on how your data is set up. I don't think you'll need a pivot chart, just a regular chart. I created a routine line chart that illustrates what I think you are going for. Depending on how your data is set up, you might be able to replace many of the constants with SUMIF formulas to get your desired effect. Can you upload an example worksheet (Go Advanced>Manage Attachments)?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks