Hi - So I currently have a pivot chart with floating bars of the pay scale for each position. The position (job title) is listed on the x-axis. I would then like to have an xy scatter plot with a point within each of those bands of where the current employees in those positions fall. I believe because the position is listed on the x-axis is a text it will not let me create a combined pivot chart.
Is there any way to get around this? Or has anyone else created a similar chart?
Is there any way to get around this? Or has anyone else created a similar chart?