Create Dashboard in Oracle APEX
Step1: Open
application
Step2: Open Home
page
Step3: Inside body
create one region
Step4: Select
Chart as type
![]()
Step5: Select type
in attribute
![]()
. Bar Chart
- Displays data using
horizontal or vertical bars.
- Best for comparing values
across categories.
- Example: Students in each
department.
2. Area Chart
- Similar to a line chart, but
the area below the line is filled.
- Shows trends over time and
emphasizes volume.
- Example: Monthly attendance
count.
3. Box Plot
- Displays statistical
distribution of data.
- Shows minimum, maximum,
median, and quartiles.
- Example: Salary distribution
of employees.
4. Bubble Chart
- Similar to a scatter chart
but includes a third value represented by bubble size.
- Useful for comparing three
dimensions of data.
- Example: Students (X=Marks,
Y=Attendance, Bubble Size=Projects).
5. Combination Chart
- Combines multiple chart
types (e.g., Bar + Line).
- Useful when comparing
different metrics.
- Example: Student Count (Bar)
and Average Marks (Line).
6. Status Meter Gauge
- Displays progress toward a
target value.
- Example: Course completion
percentage.
7. Donut Chart
- A Pie Chart with a hole in
the center.
- Shows part-to-whole
relationships.
- Example: Male vs Female
Students.
8. Funnel Chart
- Displays stages in a
process.
- Values decrease through
stages.
- Example: Admissions Process
(Applied → Selected → Enrolled).
9. Gantt Chart
- Displays tasks along a
timeline.
- Used for project scheduling.
- Example: Academic Event
Planning Schedule.
10. Line Chart
- Connects data points with
lines.
- Best for showing trends over
time.
- Example: Monthly Student
Registrations.
11. Line with Area Chart
- Combination of Line and Area
chart.
- Highlights trends and total
volume.
- Example: Daily Attendance
Trend.
12. Pie Chart
- Circular chart divided into
slices.
- Shows percentage contribution
of categories.
- Example: Students by Course.
13. Polar Chart
- Displays data in a circular
coordinate system.
- Useful for cyclical
patterns.
- Example: Monthly Performance
Analysis.
14. Pyramid Chart
- Similar to a funnel but
pyramid-shaped.
- Shows hierarchical or
proportional data.
- Example: Student Levels
(Beginner → Intermediate → Advanced).
15. Radar Chart
- Displays multiple variables
on axes from a central point.
- Useful for performance
comparisons.
- Example: Student Skills
Assessment.
16. Range Chart
- Shows minimum and maximum
values within a range.
- Example: Temperature range
across days.
17. Scatter Chart
- Displays relationships
between two numeric variables.
- Example: Marks vs
Attendance.
18. Stock Chart
- Specialized chart for
financial data.
- Displays Open, High, Low,
Close values.
- Example: Stock Market
Analysis.
Step6:Apply Query
Step7:
Map column in column mapping

|
Option |
Meaning |
|
Series
Name |
Creates
multiple series/groups |
|
Label |
X-axis
category/label |
|
Value |
Numeric
value plotted |
|
Z |
Bubble
size (Bubble Chart) |
|
Custom
Tooltip |
Tooltip
for chart points |
|
Legend
Tooltip |
Tooltip
for legend items |
|
Label
Tooltip |
Tooltip
for labels |
|
Custom
Column |
Extra
hidden data for advanced use |
Step8:
Click on run
![]()
Step9: Check on UI
Comments
Post a Comment