Hi Forum,
I have the attahced dataset and wanted to produce a pivot chart in the way explained in the attached.
Could you please help me.
Thanks
Mirisa
Hi Forum,
I have the attahced dataset and wanted to produce a pivot chart in the way explained in the attached.
Could you please help me.
Thanks
Mirisa
To create the pivot chart in the following file I formatted the Primary and Secondary Y axes, to number with no decimal places and percentage with one decimal place respectively. I also set the secondary y axis so the major axis markers are fixed at 0.1 I changed the series chart type of the Delta data to line, with no line color and selected the appropriate built in line markers under marker options and selected their solid color. I changed the transparency of the Delta data labels to 50%, gave them a color that was a shade lighter than the columns and moved them individually into their appropriate places. I changed the Income data labels to number format with no commas and no numbers after the decimal point, changed their size and moved them individually to the bottom of each column. I changed the column headings in the pivot table to Income and Delta adding an extra space to both so as to make them different from the field names in the original data set. Here is the file with the above mentioned modifications applied.
Copy of post_this.xlsx
Let me know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hi JeteMc,
Your solution is great!
Thank you so much.
Mirisa
You're welcome, and thank you for the feedback. Hope that you have a good day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks