How to have three years data in chart for comparison ?
I have three years data and i would like to compare three years data based on selection.
for ex. I would want to select.. Current Year with Previous year and Current year with Previous Year and Year Before in One chart.
I used Sumproduct to compare two years and also I can do the same three years to compare and display in one chart. But I dont know how to have selection>
please help
Hi jayeshk,
There are many fields in each worksheet, which fields do you want to chart?
Can you create a dummy mockup of how you want the chart to look?
Thanks
Remember you are unique, like everyone else
please find the sample chart... i have used Sumproduct for this chart.. i have two years data in the chart... i want to know if there is any option to add a filter to add or remove one more year of data for comparison...
Hi,
I've created a chart, not sure if it's what you want but it's a better file to use to find out what you want.
The attached file has your 3 Metrics, 'Nett Billing', 'Collections' and 'Coll %'.
I've charted a period of 12 months for these 3 Metrics for 3 years of data, 14/15, 15/16 & 16/17.
The 'Nett Billing', 'Collections' are charted on the Primary Axis & the 'Coll %' has been changed to a Line &
charted to the Secondary Axis.
Let me know what you think & if this isn't what you want, try to create something using this data if possible.
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks