hello, I have a problem where I have three columns. (file attached)
I want to create a graph with dates on the x-axis.
Data on the y-axis.
And the series name as the legend.
Does anyone know how to construct a chart from data like this. I do not want to change the columns because I am pulling data from an external source and it will be very laborious.
Thank you so so much!!!excel help.xlsx
Select your data, and insert a pivot chart.
Drag:
- Date to the Axis Field
- Name to the Legend Field
- Data to the Values
Choose chart type and format to suit.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
amazing thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks