Forum Discussion

ifiglus's avatar
ifiglus
Copper Contributor
Oct 29, 2020

HELP! - I have no idea how to do it

I want to create a (scatter?) chart that will do the following on the axes A and P: - show several items as xA, xP - show several items as xA, xP - yA, yP A similar chart I found on the net is att...
Charting
excel
  • ifiglus's avatar
    ifiglus
    Copper Contributor
    Oct 29, 2020
    Thanks, but how did you connect the two Panasonic points and how did you assign different colors to different sections?
    • Ramiz_Assaf's avatar
      Ramiz_Assaf
      Iron Contributor
      Oct 29, 2020

      ifiglus 

       

      If you noticed each type of camera is a separate scatter plot.

      you can then decide if a scatter plot has lines or not

       

      if you want I can upload another example

       

      check this tutorial

      https://www.linkedin.com/pulse/scatter-plots-excel-data-labels-ramiz-assaf/?trackingId=q02KurJ2GX0BdddDs1UV%2BQ%3D%3D

       

      • ifiglus's avatar
        ifiglus
        Copper Contributor
        Oct 31, 2020

        Ramiz_Assaf Wow! Thanks for the amazing tutorial! It will not only let me create a graphical representation of my camera lens collection, it will be a great crash course in how to create graphs in Excel. Terrific!

Resources