Forum Discussion
Scatter chart alternative
I have two measures that I want to plot over time. Average Oil ("Avg Oil (bbl/d)") and Cumulative Oil ("Cumulative Oil (bbl)"). Here is sample of the data:
| Date | Avg Oil (bbl/d) | Cumulative Oil (bbl) |
| 10/1/2017 | 1.61 | 1.61 |
| 10/2/2017 | 1.65 | 3.26 |
| 10/3/2017 | 1.61 | 4.87 |
| 10/4/2017 | 1.61 | 6.48 |
| 10/5/2017 | 1.73 | 8.21 |
| 10/6/2017 | 1.72 | 9.93 |
| 10/7/2017 | 1.67 | 11.6 |
| 10/8/2017 | 1.64 | 13.24 |
| 10/9/2017 | 1.68 | 14.92 |
| 10/10/2017 | 1.54 | 16.46 |
| 10/11/2017 | 1.72 | 18.18 |
I can do this with a Scatter chart, but I really want a line instead of bubbles.
--> I can't upload a screen shot, forum isn't letting me
I tried using an R visual, but I can't figure out what the script should be:
--> my screenshot shows a continuous level line
# dataset <- data.frame(Date, Avg Oil (bbl), Cumulative Oil (bbl))
library("ggplot2")
ggplot(dataset, aes(x = `Cumulative Oil (bbl)`, y = `Avg Oil (bbl)`)) +
geom_line()
Any ideas?
Mike
Like this?
5 Replies
Wait, why can't you use a standard Line Chart visualization?
Yeah, I wish I could upload the screen shots.
A Line chart gives me two lines, one for Avg and one for Cumulative, with 0-200 on the y-axis, and dates on the X-axis.
, I want the x-axis to show the Avg, and the y-axis to show the cumulative, one line to show the relationship of avg vs cumulative
Like this?
