You can create a chart on it’s own chart sheet or on a worksheet.
In both ways the chart is linked to the source data on the worksheet, which means the chart is updated when you update the worksheet data.
The data in your Excel sheet will be organized as a chart.
Once the chart is drawn, it becomes very easy to change the attributes, right-click the chart and you will see the options for changing chart types, data, and other formatting.
The chart or graph type will depend on the data for which you are going to plot the chart.
The most commonly used types include Column Chart, Line Graphs, Pie Chart, Bar Graph, Area Chart, Scatter Graphs, Stock Chart, and Surface Chart, among many others.
Lets discuss these chart types, and the situations in which a specific chart type is used.
The area that is covered by a specific chart is called the chart plot area.By default Excel draws charts according to the default configuration, but its very easy to edit the plot area, simply right-click the chart and choose the option.Now you will see a dialogue box which lets you set the chart’s fill style, borders, Glow and soft Edges, and 3-D effects.You need the data to be in "tall" format instead of "wide" for ggplot2."wide" means having an observation per row with each variable as a different column (like you have now).You need to convert it to a "tall" format where you have a column that tells you the name of the variable and another column that tells you the value of the variable.