Combine months of data and different clients in one chart

Hi guys,

I have a chart vaguely in mind I am trying to recreate with a differemt dataset/

Or maybe I should consider something else. Essentially, I want to know how I can present my data in one chart for 3 months (Jan-Mar) and include all the values which include numbers and percentages. Can anyubody guide me please?
Sheet attached

Thanks!

There's too much happening. It will look like a dog's breakfast!! I'd suggest doing EITHER a month at a time for all clients OR a client at a time for all months (choose via a dd box).

Hi Glenn,

Thank you for the advicer.

I have takjen a different direction and tried a pivot chart. Can yuou please guide me on how i can change the pivot chart to display percentage axis in my chart for columns e AND g? i CAN'T seem to access this on the pivot chart. i want values on the left side and percentage ont he right side as these columns have eprcentages. thank you!

You will need to attach it as an Excel workbook, not a .csv file.

Hi Ali.,

yES SURE. Excel format attachet. thank you!

Select one of the columns for either Sum of % Response Rate or % Pub rate Rate new and right click.
Choose 'Change Series Chart Type"
For the Sum of % Response Rate or % Pub rate Rate new series check the box under Secondary Axis
Format the secondary axis > Number > Percentage
[Optional] To make it more apparent which series are percentages, change the Chart Type to Line
Let us know if you have any questions.