Trend Analysis of Agricultural Crop Production in Ratnagiri District, Maharashtra Using Pivot Tables and Bar Graphs

Agricultural production is a major contributor to the economy of Maharashtra, and Ratnagiri district is well-known for its diverse crop profile, including rice, millets, pulses, and fruits like mango. Understanding the production trends of these crops over the years is essential for informed decision-making, crop planning, and resource optimization. In this study, Microsoft Excel’s pivot tables and bar graphs were used as analytical tools to process and visualize district-level crop production data. The dataset was filtered to include only Ratnagiri district, and key metrics such as total production, crop ranking, and year-wise variations were extracted. Results indicate that rice dominates the agricultural output, with a total production exceeding 3.45 million tonnes during the study period, followed by Ragi (0.38 million tonnes) and Mango (62,670 tonnes). Visualization through bar graphs revealed a clear production hierarchy among crops and highlighted the heavy dependency on rice cultivation. The findings provide valuable insights for policymakers, farmers, and agricultural planners to promote diversification, improve yields, and ensure sustainable agricultural development.