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.
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
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.
Glad you got it working, Steve.
Hopefully Phil will write a post soon on how to use VBA to format all of the series in one go.
Mynda
