I have three columns GDP, TFP and Country. I want to plot a Line chart where TFP will be on Y-Axis and GDP on X-axis. And a line chart having markers on that representing the Country. The markers of corresponding country appear on line (Line Chart) where GDP and TFP intersect. Is there any way to plot either through Excel or Tableau?
0
votes
It's not clear what question you're asking. Can you show a mock up of the chart with labels you expect? Also some data to reflect the mocked up chart?
– Andy TAR Sols
I want the country names on the line as markers while rest of the columns TFP on Yaxis and GDP on X-Axis, I am unable to show the country names on the line.
– Ehsan125
Have you tried adding a Label to the line?
– Andy TAR Sols
1 Answers
0
votes
You can put GDP and TFP under Rows and Columns, and add the Country field to Details and Label in the Marks card. Attaching an image for reference- Countries PQR and MNO both have an intersection of GDP and TFP. Dashboard Image
