![]() ![]() There will be enough time to adjust the data in the way cited by you unless there is a macro kind of thing to make the changes over a click. The more important thing is, I have to generate this report on more frequently for a huge amount of data. MS Excel Create Advanced Charts and Pivot tables. Step 4: Drag and drop Region heading to the ROWS and Sum of Amt heading to the VALUES. Step 2: Go to Insert and apply a pivot table. In my graph, there was a direct comparision for Testcases and number of defects(stacked with severity), Your solution is very much close to my requirement but is there anyway to bring the testcases bar and defects bar raising next to each other without any gap (as shown in my graph picture)ģ. I want to know the summary behind this data by using a pivot table in excel. This decision will determine how you craft your pivot chart. Decide on the statement you want your pivot chart to represent. Please correct me if I am in wrong perception.Ģ. Browse to, and open, the file containing the pivot table and source data from which you want to create a chart. I just had a relook at the data and the graph that I had sent. I was under a wrong assumption that I had responded you. I had actually replied on the thread but my comment does not seem to have published (I guess I have not pressed the final button :yikes: after typing all the stuff). I would help if you also test and comment on the feedback that other helpers have given.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |