Question

I've entered the data into Excel and created the graphs for you.

*Residential Status (Pie Graph)*
Residential Status Count
Non-resident 10
Since all students are non-residents, the pie graph will show 100% non-residents 😊.

*Province of Origin (Column Graph)*
Province Count
Eastern Highlands 4
Simbu 5
Western Highlands 1
All the above information how can i draw an pie graph and column graph please could you use this information and draw?

Answer 1

Great — I can walk you through making both charts from the data you gave. Below are step-by-step instructions for Excel (most versions 2013/2016/2019/365). I also include a quick Google Sheets option and a short Python (matplotlib) script if you prefer to generate image files.

Data to copy into your sheet:
- Table A (for pie)
Residential Status Count
Non-resident 10

- Table B (for column)
Province Count
Eastern Highlands 4
Simbu 5
Western Highlands 1

Excel: create the pie chart (Residential Status)
1. Enter the two cells (header + value): e.g. A1="Residential Status", B1="Count"; A2="Non-resident", B2=10.
2. Select A1:B2.
3. Insert tab -> Charts group -> Pie -> choose 2-D Pie (or Donut).
4. The chart appears. Click the chart to show Chart Elements (the “+” icon).
- Tick Data Labels to show the value/percentage. Right-click a label -> Format Data Labels -> check Percentage (and Value if you want both).
- Optionally remove the legend (uncheck Legend) and use the title only.
5. Double-click the Chart Title and rename to "Residential Status".
6. Format colors: right-click slice -> Format Data Point -> Fill to choose color, or use Chart Styles.
Notes: A pie chart with only one category will show a single 100% slice. That’s correct but not very informative—alternatives: show a single text box “100% Non-resident”, use a donut chart with large center text, or use a simple bar/column chart of the count.

Excel: create the column chart (Province of Origin)
1. Put the province data into two columns, headers in row1: A1="Province", B1="Count"; rows 2–4 for the three provinces and counts.
2. Select A1:B4.
3. Insert tab -> Charts -> Column or Bar -> Clustered Column.
4. Add chart elements (Chart Elements “+”):
- Chart Title: change to "Province of Origin".
- Axis Titles: add Horizontal ("Province") and Vertical ("Count").
- Data Labels: check to show counts on top of each column.
5. Format the vertical axis: right-click vertical axis -> Format Axis -> set Minimum = 0 and Major unit = 1 so ticks are integers.
6. Make bars easier to view: right-click any bar -> Format Data Series -> Gap Width (reduce to ~50% for thicker bars).
7. If you want the bars sorted by count (highest to lowest), sort the table in the worksheet before making the chart or after by editing the source data.
8. Adjust colors: right-click series -> Format Data Series -> Fill -> Solid Fill and pick colors for each bar (or pick a single color).

Google Sheets (if using Sheets)
1. Paste the data as above.
2. Select the relevant cells.
3. Insert -> Chart. Sheets usually suggests a chart; change Chart type in the Chart editor:
- For pie: choose Pie chart.
- For province: choose Column chart.
4. Use the Chart editor's Customize tab to add titles, data labels, adjust slice colors, axis ticks, etc.
5. Download chart: click the three dots on the chart -> Download -> PNG/SVG.

If you’d like to generate images with Python (matplotlib)
Copy and run this script (requires matplotlib):

import matplotlib.pyplot as plt

# Pie chart
labels = ['Non-resident']
sizes = [10]
fig1, ax1 = plt.subplots()
ax1.pie(sizes, labels=labels, autopct='%1.0f%%', startangle=90)
ax1.set_title('Residential Status')
ax1.axis('equal') # equal aspect ratio ensures pie is drawn as a circle
fig1.savefig('residential_status_pie.png', dpi=150)

# Column chart
provinces = ['Eastern Highlands', 'Simbu', 'Western Highlands']
counts = [4, 5, 1]
fig2, ax2 = plt.subplots()
bars = ax2.bar(provinces, counts, color=['#4e79a7','#f28e2b','#e15759'])
ax2.set_title('Province of Origin')
ax2.set_xlabel('Province')
ax2.set_ylabel('Count')
ax2.set_ylim(0, max(counts)+1)
for bar in bars:
height = bar.get_height()
ax2.annotate(str(int(height)),
xy=(bar.get_x() + bar.get_width() / 2, height),
xytext=(0, 3),
textcoords="offset points",
ha='center', va='bottom')
fig2.tight_layout()
fig2.savefig('province_column.png', dpi=150)

Other tips
- For presentation, add data labels and a clear title. Keep colors consistent and avoid too many effects.
- To export a chart in Excel: right-click chart -> Save as Picture (or copy and paste into Word/PowerPoint).
- If you want the province bars sorted by count, sort the worksheet rows first (descending by Count) before making the chart.

If you want, I can:
- Make the charts for you and send PNGs (if you allow me to create images here), or
- Provide a ready-to-paste CSV string or a step-by-step with screenshots.

Which would you prefer?