Hello!
I have a file that has four fields date, name, t_count and c_count and I want to capture all fields in one single chart. Since the names are repeated on different dates, I am unable to create one. I tried a pivot chart method but the chart is looking garbled and I cant make out anything. Can someone advice how to make a presentable chart or a pivot chart with the attached data? Thanks
As with any such question it depends what the point is that you're trying to get across to your reader. The same data can be presented in different ways and one will be better than the other for a particular user.
You haven't offered us much idea but see if the attached gets you started.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks. I was looking somewhat similar to that. You have given me a start. Let me play around with options. I will get back if I need some help/advice. Meanwhile, I would appreciate if you can give me steps on how to draw the chart and get the secondary axis option. Also how to put the secondary scale on the right.
I was able to achieve what I wanted. Thanks for your support.
My pleasure and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks