K kihoro New Member Mar 20, 2013 #1 hi guys, i need to create a dynamic chart where the months are in columns as opposed to rows. it should dynamically chart for the last 12 months.. jan12 , feb 12 , march 12 , april 12, may 12 kemsa : 122 332 555 666 777 kenya pharma: 333 443 545 545 5454
hi guys, i need to create a dynamic chart where the months are in columns as opposed to rows. it should dynamically chart for the last 12 months.. jan12 , feb 12 , march 12 , april 12, may 12 kemsa : 122 332 555 666 777 kenya pharma: 333 443 545 545 5454
J jason Member Mar 20, 2013 #2 what is your data setup like? can you upload a sample file?! a pivot table may be a great option. then once you have the data arranged how you want in the pivottable, you can create a pivotchart to reflect it.
what is your data setup like? can you upload a sample file?! a pivot table may be a great option. then once you have the data arranged how you want in the pivottable, you can create a pivotchart to reflect it.
