How can I turn the values [from the left] to this kind of monthly-sum graph as the preview graph shows [from the right]
Thanks in advance
a.jpg
How can I turn the values [from the left] to this kind of monthly-sum graph as the preview graph shows [from the right]
Thanks in advance
a.jpg
Last edited by dlnes; 12-11-2014 at 06:30 PM.
Do you specifically want the dotted lines up to the total money amount? Attached is a pivot chart. Would that serve your purposes?
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
Thank you first of all!
Yes, Your attachment is exactly as I wish it to be.
Now, How to make the chart updateable by the Date&Amt(A:A & B:B) columns?
Thanks
You can select A:B when creating the pivot chart (Insert>Pivot> Chart)
Then group the date by month and year
Pivot charts unfortunately need to be refreshed when you add data. So after adding raw data, right click on the pivot data and "refresh"
It helped!
I give you rep and I thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks