Hvordan vises / tilføjes datatabel i diagram i Excel?
Nogle gange er vi nødt til at kombinere datatabellen og datakortet sammen for nemt at analysere dataene i diagrammet. Nu vil jeg fortælle dig en måde at tilføje datatabellen til et diagram i Excel.
Overlad dine Excel-færdigheder med Kutools til Excel, og oplev effektivitet som aldrig før. Kutools til Excel tilbyder over 300 avancerede funktioner for at øge produktiviteten og spare tid. Klik her for at få den funktion, du har mest brug for...
This comment was minimized by the moderator on the site
On my new and latest version of Excel, Chart Tools only has two subsidiary Tabs i.e. Design & Format. There is not one for Layout.
I just want to add a Legend below the horizontal data.
Please advise.
This comment was minimized by the moderator on the site
Click on your Chart>>Click on the DESIGN tab>>Click on the QUICK LAYOUT (2nd from left)>>You will find a number of layouts there to chose from.
Layout number 5 is with the Data Table.
or Alternatively
Click on your Chart>>Click on the Green + sign at the Top right of your Chart>>Tick Data Tables from there.