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?


Bitcoin Price Chart – Bitcoin Breakout to $12k

Platinum Crypto Academy


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", 
       "aaaaaaaaaaaaaaaaaaaaaaa", "aasdadasfsafasfsafasfa", 
       "afsafasfasfasfasfsafsab", "casfasfafsafsafsafsa", 
    labeledDat = 
     Labeled[dat [[#]], labels[[#]], "VerticalCallout"] & /@ 
    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:

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

=importxml("", "/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?


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

Public Sub FormatProductHeaderLabel()
End Sub

Public Sub FormatServiceHeaderLabel()
End Sub

Here is one implementation:


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
    HeaderColumn As Long
    HeaderData As Scripting.Dictionary
    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 .HeaderData = hData
        Set .ChartWorksheet = cSheet
        Set Create = .Self
    End With
End Function

Public Property Get HeaderData() As Scripting.Dictionary
    Set HeaderData = this.HeaderData
End Property

Public Property Set HeaderData(ByVal value As Scripting.Dictionary)
    Set this.HeaderData = value
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
    HeaderColumn = this.HeaderColumn
End Property

Public Property Let HeaderColumn(ByVal value As Long)
    this.HeaderColumn = value
End Property

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

Private Sub BuildHeaders()
    Application.ScreenUpdating = False
    Dim product As Variant
    For Each product In HeaderData
        PrintProductValues product
        this.HeaderColumn = this.HeaderColumn + 1
        Dim service As Variant
        For Each service In HeaderData(product)
            PrintServiceValues service
            this.HeaderColumn = this.HeaderColumn + 1
    Application.ScreenUpdating = True
End Sub

Private Sub PrintProductValues(ByVal product As String)
    With this.ChartWorksheet.Range(Cells(4, this.HeaderColumn), Cells(50, this.HeaderColumn))
        .Interior.Color = InteriorProductColumnColor
    End With

    With Sheet3.Cells(4, this.HeaderColumn)
        .value = product
    End With
End Sub

Private Sub PrintServiceValues(ByVal service As String)
    With this.ChartWorksheet.Cells(4, this.HeaderColumn)
        .value = Mid(service, 14, 100)
    End With
End Sub

Private Sub IChartFormatService_FormatProductHeaderLabel()
    With this.ChartWorksheet.Cells(4, this.HeaderColumn)
        .Font.Name = ProductHeaderFont
        .Font.Size = ProductHeaderFontSize
        .Font.Color = ProductHeaderFontColor
        .Font.Bold = True
        .Orientation = Excel.XlOrientation.xlUpward
    End With
End Sub

Private Sub IChartFormatService_FormatServiceHeaderLabel()
    With this.ChartWorksheet.Cells(4, this.HeaderColumn)
        .Interior.Color = InteriorServiceColumnColor
        .Font.Name = ServiceHeaderFont
        .Font.Size = ServiceHeaderFontSize
        .Font.Bold = False
        .Font.Color = ServiceHeaderFontColor
        .Orientation = Excel.XlOrientation.xlUpward
    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()
    this.HeaderColumn = 3
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)
End Sub

Snippet of what’s produced

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

enter image description here

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.

enter image description here

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:


I did the same exercise for 2019 and 2020

then I plotted it like this:

fig = go.FigureWidget()
fig.add_trace(go.Scatter(x=Line_2020.index, y=Line_2020,
                    name='Turnover 2020'))
fig.add_trace(go.Scatter(x=Line_2019.index, y=Line_2019,
                    name='Turnover 2019'))
fig.add_trace(go.Scatter(x=Line_2018.index, y=Line_2018,
                    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

looking to do this in the Anycharts Qlik extension.