Line Chart Template
Plot crude oil prices over time as a line chart with labeled axes, data points, and annotations. Drop in your own numbers to chart any commodity or metric trend.
Use this templateWhat you get
- Labeled X/Y axes with price gridlines
- Multi-point trend line with value markers
- Callout annotations for key turning points
What this template is for
The template uses six invented practice values—61, 78, 118, 106, 105 and 69—to illustrate a rise and fall. They are not observed oil prices from 2026 or any other year. Replace the labels, values and title for a compact trend chart. The current element supports one numeric series and evenly spaced categories, rather than date-aware spacing, missing-value gaps or source-sheet synchronization.
When to use this template
- Chart a commodity or stock price over time (oil, gold, a ticker) to show the trend behind the headlines.
- Plot monthly revenue, signups, or active users for a report or investor update.
- Track a KPI week over week and share the trend with your team without opening a spreadsheet.
- Show website traffic or conversion rate across a campaign period.
- Visualize temperature, weight, or any measurement logged over days or months.
- Compare a single metric's before-and-after across a project to make the impact obvious.
How to use it
- 1Open the template — it loads with a sample trend line and labeled axes.
- 2Double-click the chart to open the data editor on the side.
- 3Edit each point's label (the x-axis category) and value, or add and remove points.
- 4Drag any data point up or down directly on the canvas to fine-tune its value.
- 5Leave the Y axis on auto range so it always fits your data, or set a fixed min/max for a consistent scale.
- 6Add a title, toggle value labels or gridlines, and recolor the line to match your brand.
Quick example
Invented price exercise (illustrative units)
How it compares to similar tools
Line chart vs. table
A table lists exact numbers but hides the shape of the trend. A line chart makes the rise, fall, and turning points obvious in one look — use a table when precision matters most, a line chart when the story is the change over time.
Line chart vs. bar chart
Use a line chart for a continuous metric measured at regular intervals (price by month, users by week) where the trend between points is meaningful. Use a bar chart to compare separate categories that have no natural order between them.
Common mistakes to avoid
Truncating the Y axis
A clearly labeled cropped range can be appropriate for line charts. The zero-based automatic range for non-negative values is a software default; choose a defensible scale and check ranges before comparing slopes.
Too many points crammed together
Twenty labels on one line become an unreadable smear. Aggregate to a coarser interval (months instead of days) or split into multiple charts when the data is dense.
Equal spacing for unequal time gaps
The current element spaces categories evenly. Use a suitable date-aware or gap-capable tool for irregular intervals or missing observations; changing labels does not change spacing.
Frequently asked questions
Can I edit the data points?+
Yes. Double-click the chart to open the data editor, then change each point's label and value, or add and remove points. You can also drag any point up or down on the canvas to change its value directly.
Does the axis scale automatically?+
By default the Y axis auto-fits your data (starting at 0 when all values are positive). You can turn auto range off and set a fixed minimum and maximum if you need a consistent scale across several charts.
Can I use it for data other than oil prices?+
Absolutely. The oil price is just a worked example. Replace the labels and values with revenue, users, temperature, scores, or any metric tracked over time.
Do I need an account?+
No. Open the template and start editing immediately. Sign in only if you want to save your chart to your dashboard.
Start editing online
Open the template in CodePic, replace the sample content, and make it your own in a few minutes.
See examples: /templates/oil-price-trend/examples


