Dynamic Range not capturing all data in Pivot Charts

I have a dynamic pivot table/chart but for some reason, it is not capturing all of the information within the chart labeled "Closed SRs by Severity". If you look at the chart, you can see it is not including all the information there. Any help here? The chart(s) is located in the tab labeled "Charts of SRs" all the way at the bottom right. I believe both open and closed charts do not capture all the data for severity.
DSE-Carelog-Report-V1.xlsm
AckeemKAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SANTABABYCommented:
The data range selection for the chart was partial. Fixed it. See attached.
DSE-Carelog-Report-V1.xlsm
0
AckeemKAuthor Commented:
I see that it is not displaying data that sits under the S4 column on the chart. Is there a way to include that data as well? Usually it can go up to S7 depending on the data within the 'Current' and 'Closed' tab.
0
SANTABABYCommented:
Added another series in the chart for S4(for Closed SRs). Attached. More of them can be added by clicking Right Mouse button on the chart and then by choosing select Data followed by "add" under Legend Series.
DSE-Carelog-Report-V2.xlsm
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

you may do better by creating a pivot chart instead pointing a regular chart at a pivot table. While it is easy to have dynamic ranges for how many data points are in a series, it is not possible to have a dynamic number of series. That's what pivot charts do much better.

cheers, teylyn
0
AckeemKAuthor Commented:
Two things. I noticed in the legend, there is no Developer Support and also I see that in the chart it is including months that have no data. Any quick fixes to this?
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Which of the comments are you replying to? Can you add the name of the expert, please. Otherwise nobody will know who you mean.
0
AckeemKAuthor Commented:
Since @Santababy has helped me with this question, I am replying to that expert. However, pivot charts as you mentioned @teylyn, are not as easy done in the excel for Mac 2011 which is why I moved towards dynamic ranges.
0
SANTABABYCommented:
Hello,
For empty months, I can think of multiple ways to not show them. However, when I looked at your source data and chart, I saw that the data range was reset to partial selection and that's why some months were showing no data in the chart but they actually have data. I Fixed them and also removed and re-added the Dev Support legend.
Please take a look. (Note that I'm on windows, Pivot Charts are nice and can help you, but I can't address the issues with Pivot Charts that are specific to Mac).
Thanks.
DSE-Carelog-Report-V2.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.