google sheets – How to make time series chart, where all rows are labelled and dates are not unique?

Say I have some data like so

``````| Month | Count | Type |    |    |
|-------|-------|------|--- |--- |
|     1 |     2 | A    |    |    |
|     1 |     3 | B    |    |    |
|     2 |     1 | A    |    |    |
|     2 |     2 | B    |    |    |
|     3 |     1 | A    |    |    |
|     3 |     1 | B    |    |    |​
``````

I would like to create a line chart, which each Type would have its own line.

In data studio this behaviour is set by default, but is there an easy way to do it with google sheets?

Thanks

Bitcoin Price Chart – Bitcoin Breakout to \$12k

Bitcoin Price Chart – Bitcoin Breakout to \$12k

As Bitcoin’s price chart rises, the block reward becomes increasingly more attractive for miners/traders/investors. Key Trading on our Bitcoin price chart.

#Bitcoin #Cryptocurrencies #CryptoMarketAnalysis #BTCUSD #ETHUSD #XRPUSD #BCHUSD #BSVUSD

plotting – pie chart plot formatting

I have been looking through numerous stack posts to answer 1-4 below.
I am trying to generate a pie chart with several very small slices that have long labels.

1. when I do the callouts how can I eliminate the dots that point to the slices of the pie? I’m really confused because on the examples on the PieChart function on the Mathematica website the labels don’t work out.
2. how do I get the labels not to overlap? I tried both “RadialCallout” and “VerticalCallout” but the labels themselves are so small
3. how can I get the sides of the plot not get chopped off while still using “VerticalCallout”? I tried playing with the padding parameter but my labels still get chopped
4. how can I get the pie chart title closer to the plot?

Here’s a working example of my code:

``````    dat  = {0.001, 0.001, 0.001, 1, 2, 3, 4};
labels = {"bbbbbbbbbbbbbb", "ccccccccccccccccccccc",
"afsafasfasfasfasfsafsab", "casfasfafsafsafsafsa",
"gwegwgwhhtrwhtrjrjwtud"};
labeledDat =
Labeled[dat [[#]], labels[[#]], "VerticalCallout"] & /@
Range[Length[dat]]

PieChart[labeledDat, SectorOrigin -> {Automatic, 1},
PlotLabel -> "Donut Plot", ColorFunction -> "Rainbow"]

``````

Getting web data into Google Sheets – from formatted chart

I am trying to get the data from this web page into a Google sheet:

https://www.validea.com/factor-report/aapl

For example for the value `77` in the chart near the bottom, I had been using `importxml` but it returns `#N/A`:

``````=importxml("https://www.validea.com/factor-report/AAPL", "/html/body/form/div/div/div(6)/div/div(1)/div/svg/g(1)/g(4)/g(24)/g/g/text(2)")
``````

How do you pull the data from the chart, and is there a way to pull the data in once so that each item doesn’t need to re-query the page?

Any help is much appreciated.

object oriented – Creating a Chart Worksheet from scratch with VBA / OOP Design

I recently posted some code for review, and am now looking to gather some feedback on my latest implementation with that code. Yes, I have fallen into the OOP rabbit hole (thanks Matthew Guindon) and am curious if my OOP approach is on the right track.

Some background: I am creating a Chart Workbook from scratch via data that is generated from a Bot at work. Basically I take the data from the Bot generated Workbook, store it into an Array and then use a `Scripting Dictionary` to sort out all the duplicates, this approach works great! My code below is merely just the Worksheet part of my project, and am only at the point of creating the Headers for said chart.

Am I on the right track so far?

IChartFormatService

My hope was to separate this concern from my `ChartWorksheet` class.
Why would I want to do that? In the future I may need to implement
different styles for different reasons, based on customer / work
needs. I can have a particular `Worksheet` implement a particular
flavor of colors for different representations.

``````Option Explicit

End Sub

End Sub
``````

Here is one implementation:

StandardChartWorkSheet

``````Option Explicit

Implements IChartFormatService
Implements IChart

Private Const ProductHeaderFont As String = "Arial"
Private Const ProductHeaderFontSize As Integer = 12
Private Const ProductHeaderFontColor As Long = 16777215

Private Const ServiceHeaderFont As String = "Arial"
Private Const ServiceHeaderFontSize As Integer = 10
Private Const ServiceHeaderFontColor As Long = 0

Public Enum ChartColor
InteriorProductColumnColor = 12549120
InteriorServiceColumnColor = 14277081
End Enum

Private Type TChartWorksheetService
ChartWorksheet As Worksheet
End Type

Private this As TChartWorksheetService

Public Function Create(ByVal hData As Scripting.Dictionary, cSheet As Worksheet) As IChart
With New StandardChartWorksheet
Set .ChartWorksheet = cSheet
Set Create = .Self
End With
End Function

Public Property Get HeaderData() As Scripting.Dictionary
End Property

Public Property Set HeaderData(ByVal value As Scripting.Dictionary)
End Property

Public Property Get ChartWorksheet() As Worksheet
Set ChartWorksheet = this.ChartWorksheet
End Property

Public Property Set ChartWorksheet(ByVal value As Worksheet)
Set this.ChartWorksheet = value
End Property

Public Property Get HeaderColumn() As Long
End Property

Public Property Let HeaderColumn(ByVal value As Long)
End Property

Public Property Get Self() As IChart
Set Self = Me
End Property

Application.ScreenUpdating = False
Dim product As Variant
PrintProductValues product
Dim service As Variant
PrintServiceValues service
Next
Next
Application.ScreenUpdating = True
End Sub

Private Sub PrintProductValues(ByVal product As String)
.Interior.Color = InteriorProductColumnColor
End With

.value = product
End With
End Sub

Private Sub PrintServiceValues(ByVal service As String)
.value = Mid(service, 14, 100)
End With
End Sub

.Font.Bold = True
.Orientation = Excel.XlOrientation.xlUpward
.Columns.AutoFit
End With
End Sub

.Interior.Color = InteriorServiceColumnColor
.Font.Bold = False
.Orientation = Excel.XlOrientation.xlUpward
.Columns.AutoFit
End With
End Sub

Private Sub IChart_BuildChart()
If Not this.HeaderData Is Nothing Then
Else: Exit Sub
End If
End Sub

Private Sub Class_Initialize()
End Sub
``````

`StandardChartWorksheet` class implements another interface, `IChart` basically separating the concern of building a chart

``````Option Explicit

Public Sub BuildChart()
End Sub
``````

My sample procedure, housed in Module 1

``````Sub test()
Dim chart As IChart
Set chart = StandardChartWorksheet.Create(GetTMProductDictionary, Sheet3)

chart.BuildChart
End Sub
``````

Snippet of what’s produced

There are 50 more columns, cropped the picture to keep it simple.

google sheets – Can’t get chart to display weeks from specified day

I can’t for the life of me get my chart to display every Monday (starting from 13/07, instead it displays every Sunday (starting with 12/07).The chart also starts with 6 data points (minor lines) and then continues afterwards with 7.

The dates in the green color (left side) are the dates that I wish to use. I have it set as 23 major grid lines as that is how many Sunday’s I have.

Excel Web Access – Chart linked to external workbook not pulling data

In short, I have two Excel workbooks (2 separate files) on SharePoint 2016. The first is a bunch of data. The second is analysis of the data, charts, etc. in the form of a dashboard. All of the formulae used to analyze/summarize the data refer back to the first workbook.

I want the dashboard to show up on a SharePoint page, so I have implemented the Excel Web Access app. When I first tried to load the file with the dashboard, I got an error noting that I couldn’t link charts or objects to an external data source. I played around with things a bit, removing the charts and adding them back in 1 by 1 to see if I could pinpoint where the issue is.

I managed to get past the dashboard not loading at all, but for some reason I can only get two of the four charts to properly display. The two charts that work fine are referring to the external data source. The two charts that aren’t displaying are also linked to the same data. When I open the dashboard Excel file, everything looks fine. When I look at the formulae in the data tab in the dashboard, the cells all have “VALUES” in them.

Any insight as to why the two charts won’t have their data recognized in the SharePoint app?

pandas – Python: Plot year-over-year comparison of cumulated turnover as a line chart

So I have the following challenge:
I have a list of data from 2018 to July 2020 as DateTime
I have turnover attached to each date positions
What I want to achieve is a line plot that starts from the same origo point and shows the development over the past years. Currently, x axis shows 2018,2019,2020 separately.

I cumulated the turnover for each year like this:
for 2018:

``````df_2018=df.loc('2018-01-01':'2018-12-31')
df_2018("Turnovercum")=df_2018("Turnover").cumsum()
Line_2018=df_2018("Turnovercum")
Line_2018
``````

I did the same exercise for 2019 and 2020

then I plotted it like this:

``````fig = go.FigureWidget()
mode='lines',
name='Turnover 2020'))
mode='lines',
name='Turnover 2019'))
mode='lines',
name='Turnover 2018'))
``````

Do you have any suggestions on how to plot it in a way that all the 3 lines are starting from the same origo?This is how it looks like at this moment

Any help or links where to look this up is much appreciated!

scraping – How can I download raw data from a plotly chart?

Stack Exchange Network

Stack Exchange network consists of 177 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Is there a way to enable scroller in Anycharts Qlik Sense extension, eg Bar Chart?

Is there a way to enable scroller in Anycharts Qlik Sense extension, eg Bar Chart ?

For example, in Anycharts set using
// turn on X Scroller
chart.xScroller(true);

looking to do this in the Anycharts Qlik extension.

Thanks