Log In
Register
Home
New Member
November 5, 2018
Offline
Hi, I'm having some difficulty in creating the pivot chart for the recent Dot Plot tutorial. I've managed to create the manual versions, with and without a highlighted sport: the same data was copied then Formatted as a Table for the pivot chart. Try as I might, I can't seem to get the categories labels to appear on the X axis: the Y axis (0-10) is OK. Swapping Sport and categories between Row/Column has not helped, neither has putting the categories into Values with Sport as a Row label (close - but no cigar!!).
I've been collecting other advanced graph types and these are in the attached workbook. My sample data is on the worksheet wsVerticalDot. Any help appreciated.
July 16, 2010
Offline
Hi Steve,
It's because your source data for the PivotTable is not in a tabular format. If you look at my source data you'll see there are 3 columns: Skill, Sport and Value/score.
You need to unpivot your data first. You can use Power Query to unpivot your data.
Mynda
New Member
November 5, 2018
Offline
Hi Mynda, Thanks for your reply. I started over, arranging the data into 3 columns worked a treat. It's definitely a labour of love editing the marker points!! I used the Alt key to position the two charts to overlap.
1 Guest(s)
