I need to plot multiple axis graph

What about this one?

C-Series are on the secondary axis, primary axis has a logarithmic scale.

Andreas.

Excel 365 Pro Plus with Power Pivot and Power Query.

Plot with three Y axes.

With superimposed PivotCharts.

https://www.mediafire.com/file_premium/9tg03k2ag8or1qt/07_13_23.xlsx/file

https://www.mediafire.com/file_premium/5s8i3yy6kiyb9jl/07_13_23.pdf/file

Hi Shirfil

I'm AnnaThomas and I'd happily help you with your question. In this Forum, we are Microsoft consumers just like yourself.

You can create a multiple-axis by adding a secondary vertical axis to the chart. You can follow the steps below

Select your data, including the column headers, and click on the Insert tab. In the Charts group, click on the Column chart type and select a Clustered Column chart. Right-click on one of the data series (e.g., B1) and select Format Data Series. In the Format Data Series pane, click on the Series Options category and select Secondary Axis. Click on the Close button to close the Format Data Series pane.

Now you should see a secondary vertical axis on the right side of the chart. You can repeat steps 3-5 for any other data series you want to plot on the secondary axis.

I hope this helps ;-), let me know if this is contrary to what you need, I would still be helpful to answer more of your questions.

Best Regards,

AnnaThomas

Give back to the community. Help the next person with this problem by indicating whether this answer solved your problem. Click Yes or No at the bottom.

Hi,

What data do you want plotted for each of the lines. I see 9 series A1,A2,A3,B1,B2,B3,C1,C2 and C3. Do you want to plot the dates on the x-axis?

Thanks,

Shane

Hi Shirfil I'm AnnaThomas and I'd happily help you with your question. In this Forum, we are Microsoft consumers just like yourself. You can create a multiple-axis by adding a secondary vertical axis to the chart. You can follow the steps below Select your data, including the column headers, and click on the Insert tab. In the Charts group, click on the Column chart type and select a Clustered Column chart. Right-click on one of the data series (e.g., B1) and select Format Data Series. In the Format Data Series pane, click on the Series Options category and select Secondary Axis. Click on the Close button to close the Format Data Series pane. Now you should see a secondary vertical axis on the right side of the chart. You can repeat steps 3-5 for any other data series you want to plot on the secondary axis. I hope this helps ;-), let me know if this is contrary to what you need, I would still be helpful to answer more of your questions. Best Regards, AnnaThomas Give back to the community. Help the next person with this problem by indicating whether this answer solved your problem. Click Yes or No at the bottom.

Hi,

Thanks for the reply Ms. AnnaThomas,

Actually i need every thing to be plotted in line graph. Since the values comes for different ranges for different series, it is very difficult for the user to make analysis analysis. I feel 3 seperate y-axes should be there atleast, for a successfull data visulization.

Regards,

Shirfil