{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Graf vkládaní","Typy - grafu"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Graf vkládaní","index":0,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Vytvořit graf"]
[]
[null,"den","naspořeno A","naspořeno B",null,"Graf v listu verze 1",null,"Graf 1 verze 2"]
[null,"2010-01-01",10,30]
[null,{"$f":"B4+1","v":"2010-01-02"},11,31]
[null,{"$f":"B5+1","v":"2010-01-03"},12,30]
[null,"2010-01-04",12,32]
[null,"2010-01-05",14,30,null,null,null,"Dim rng As Range"]
[null,"2010-01-06",18,31,null,null,null,"Dim cht As Object"]
[null,"2010-01-07",24,30]
[null,"2010-01-08",32,35,null,"    ActiveSheet.Shapes.AddChart.Select",null,"Set rng = ActiveSheet.Range(\"B3:D19\")"]
[null,"2010-01-09",40,30,null,null,null,"Set cht = ActiveSheet.Shapes.AddChart"]
[null,"2010-01-10",60,32,null,"    ActiveChart.SetSourceData Source:=Range(\"List1!$B$3:$D$19\")"]
[null,"2010-01-11",61,32,null,"    ActiveChart.ChartType = xlLineStacked",null,"cht.Chart.SetSourceData Source:=rng"]
[null,"2010-01-12",65,32,null,null,null,"cht.Chart.ChartType = xlLineStacked"]
[null,"2010-01-13",70,32]
[null,"2010-01-14",72,32]
[null,"2010-01-15",74,32]
[null,"2010-01-16",78,32,null,"Graf v samostatném listu verze 1"]
[]
[]
[]
[]
[null,null,null,null,null,"Set VlozitGraf = Charts.Add"]
[]
[null,null,null,null,null,"With VlozitGraf "]
[null,null,null,null,null,".SetSourceData Source:=Sheets(\"Sheet1\").Range(\"B3:D19\")"]
[null,null,null,null,null,".ChartType = xlColumnClustered"]
[null,null,null,null,null,"End With"]
[]
[]
[null,null,null,null,null,"Graf v  listu velikost pozice",null,"Graf v  listu velikost pozice"]
[]
[]
[]
[]
[null,null,null,null,null,"Dim rng As Range",null,"Dim rng As Range"]
[null,null,null,null,null,"Dim cht As Object",null,"Dim cht As Object"]
[]
[null,null,null,null,null,"Set rng = ActiveSheet.Range(\"B3:D19\")",null,"Set rng = ActiveSheet.Range(\"B3:D19\")"]
[null,null,null,null,null,"Set cht = ActiveSheet.ChartObjects.Add(50, 40, 200, 100)",null,"Set cht = ActiveSheet.ChartObjects.Add _"]
[null,null,null,null,null,null,null,"    (Left:=100, Width:=375, Top:=75, Height:=225)"]
[null,null,null,null,null,"cht.Chart.SetSourceData Source:=rng"]
[null,null,null,null,null,"cht.Chart.ChartType = xlLineStacked"]
[null,null,null,null,null,null,null,"cht.Chart.SetSourceData Source:=rng"]
[null,null,null,null,null,null,null,"cht.Chart.ChartType = xlLineStacked"]
[]
[]
[null,null,null,null,null,"Graf v listu se jménem"]
[]
[]
[]
[]
[null,null,null,null,null,"Dim rng As Range"]
[null,null,null,null,null,"Dim cht As Object"]
[]
[null,null,null,null,null,"Set rng = ActiveSheet.Range(\"B3:D19\")"]
[null,null,null,null,null,"Set cht = ActiveSheet.ChartObjects.Add(50, 40, 200, 100)"]
[]
[null,null,null,null,null,"cht.Chart.SetSourceData Source:=rng"]
[null,null,null,null,null,"cht.Chart.ChartType = xlLineStacked"]
[null,null,null,null,null,"cht.Name = \"MujGraf\""]
[]
[null,null,null,null,null," pro další úpravy"]

{"sheet":"Typy - grafu","index":1,"n_rows":94,"n_cols":5,"rows_kept":94,"cut":false,"hidden":false,"merged":[[90,1,90,4],[88,1,89,4],[78,1,78,4],[83,1,83,4],[0,0,0,5],[1,0,1,5],[50,1,50,4],[53,1,53,4],[61,1,61,4],[68,1,68,4],[72,1,72,4],[27,1,27,4],[30,1,30,4],[4,1,4,4],[11,1,11,4]]}
["Vytvořit graf"]
["http://offie.lasakovi.com/"]
[]
[null,"TYP GRAFU v EN","Graf v CZ","VALUE","VBA CONSTANTA"]
[null,"AREA"]
[null,"3D AREA","Prostorový plošný",-4098,"xl3DArea"]
[null,"3D STACKED AREA","Skladaný plošný s prostorovým efektem",78,"xl3DAreaStacked"]
[null,"3D 100% STACKED AREA","100% Skladaný plošný s prostorovým efektem",79,"xl3DAreaStacked100"]
[null,"AREA","Plošný",1,"xlArea"]
[null,"STACKED AREA","Skladaný plošný",76,"xlAreaStacked"]
[null,"100% STACKED AREA","100% Skladaný plošný",77,"xlAreaStacked100"]
[null,"BAR"]
[null,"3D CLUSTERED BAR","Skupinový pruhový s prostorovým efektem",60,"xl3DBarClustered"]
[null,"3D STACKED BAR","Skladaný pruhový s prostorovým efektem",61,"xl3DBarStacked"]
[null,"3D 100% STACKED BAR","100% Skladaný pruhový s prostorovým efektem",62,"xl3DBarStacked100"]
[null,"CLUSTERED BAR","Skupinový pruhový",57,"xlBarClustered"]
[null,"STACKED BAR","Skladaný pruhový",58,"xlBarStacked"]
[null,"100% STACKED BAR","100% Skladaný pruhový",59,"xlBarStacked100"]
[null,"CLUSTERED CONE BAR","Skupinový prostorový kuželový",102,"xlConeBarClustered"]
[null,"STACKED CONE BAR","Skládaný prostorový kuželový",103,"xlConeBarStacked"]
[null,"100% STACKED CONE BAR","100% Skupinový prostorový kuželový",104,"xlConeBarStacked100"]
[null,"CLUSTERED CYLINDER BAR",null,95,"xlCylinderBarClustered"]
[null,"STACKED CYLINDER BAR",null,96,"xlCylinderBarStacked"]
[null,"100% STACKED CYLINDER BAR",null,97,"xlCylinderBarStacked100"]
[null,"CLUSTERED PYRAMID BAR",null,109,"xlPyramidBarClustered"]
[null,"STACKED PYRAMID BAR","Skládaný prostorový jehlanový",110,"xlPyramidBarStacked"]
[null,"100% STACKED PYRAMID BAR",null,111,"xlPyramidBarStacked100"]
[null,"BUBBLE - bublinový"]
[null,"3D BUBBLE, BUBBLE WITH 3D EFFECTS","Bublinový s prostorovým efektem",87,"xlBubble3DEffect"]
[null,"BUBBLE","Bublinový",15,"xlBubble"]
[null,"COLUMN - sloupcové"]
[null,"3D CLUSTERED COLUMN","Prostorový pruhový",54,"xl3DColumnClustered"]
[null,"3D COLUMN","Skupinový pruhový s prostorovým efektem",-4100,"xl3DColumn"]
[null,"3D CONE COLUMN","Skupinový vodorovný kuželový",105,"xlConeCol"]
[null,"3D CYLINDER COLUMN","Skupinový vodorovný valcový",98,"xlCylinderCol"]
[null,"3D PYRAMID COLUMN",null,112,"xlPyramidCol"]
[null,"3D STACKED COLUMN","Prostorový průhový skládaný",55,"xl3DColumnStacked"]
[null,"3D 100% STACKED COLUMN","100% prostorový pruhový skládaný",56,"xl3DColumnStacked100"]
[null,"CLUSTERED COLUMN","Skupinový sloupcový",51,"xlColumnClustered"]
[null,"STACKED COLUMN","Skládaný slooupcový",52,"xlColumnStacked"]
[null,"100% STACKED COLUMN","100% skladaný sloupcový",53,"xlColumnStacked100"]
[null,"CLUSTERED CONE COLUMN","Skupinový kuželový",99,"xlConeColClustered"]
[null,"STACKED CONE COLUMN","Skládaný kuželový",100,"xlConeColStacked"]
[null,"100% STACKED CONE COLUMN","100% Skládaný kuželový",101,"xlConeColStacked100"]
[null,"CLUSTERED CYLINDER COLUMN",null,92,"xlCylinderColClustered"]
[null,"STACKED CYLINDER COLUMN",null,93,"xlCylinderColStacked"]
[null,"100% STACKED CYLINDER COLUMN",null,94,"xlCylinderColStacked100"]
[null,"CLUSTERED PYRAMID COLUMN",null,106,"xlPyramidColClustered"]
[null,"STACKED PYRAMID COLUMN","Skládaný jehlanový",107,"xlPyramidColStacked"]
[null,"100% STACKED PYRAMID COLUMN",null,108,"xlPyramidColStacked100"]
[null,"DOUGHNUT"]
[null,"DOUGHNUT","Prstencový",-4120,"xlDoughnut"]
[null,"EXPLODED DOUGHNUT","Rozložený prstencový",80,"xlDoughnutExploded"]
[null,"LINE - Spojnicový"]
[null,"3D LINE","Prostorový spojnicový",-4101,"xl3DLine"]
[null,"LINE","Spojnicový",4,"xlLine"]
[null,"LINE WITH MARKERS","Spojnicový se značkami",65,"xlLineMarkers"]
[null,"STACKED LINE","Skládaný spojnicový",63,"xlLineStacked"]
[null,"100% STACKED LINE","100% Skládaný spojnicový",64,"xlLineStacked100"]
[null,"STACKED LINE WITH MARKERS",null,66,"xlLineMarkersStacked"]
[null,"100% STACKED LINE WITH MARKERS",null,67,"xlLineMarkersStacked100"]
[null,"PIE - výsečový koláčový"]
[null,"3D PIE","Výsečový s prostorovým efektem",-4102,"xl3DPie"]
[null,"3D EXPLODED PIE","Rozložený výsečový s prostorovým efektem",70,"xl3DPieExploded"]
[null,"BAR OF PIE","Výsečový s dílčimy pruhy",71,"xlBarOfPie"]
[null,"EXPLODED PIE","Rozložený výsečový",69,"xlPieExploded"]
[null,"PIE","Výsečový",5,"xlPie"]
[null,"PIE OF PIE","Výsečový s dílčí výsečí",68,"xlPieOfPie"]
[null,"RADAR - paprskový"]
[null,"RADAR","Paprskový",-4151,"xlRadar"]
[null,"FILLED RADAR","Paprskový s výplní",82,"xlRadarFilled"]
[null,"RADAR WITH DATA MARKERS","Paprskový se značkami",81,"xlRadarMarkers"]
[null,"SCATTER"]
[null,"SCATTER","Bodový pouze se zančkami",-4169,"xlXYScatter"]
[null,"SCATTER WITH LINES","Bodový s rovnými spojnicemi a značkami",74,"xlXYScatterLines"]
[null,"SCATTER WITH LINES AND NO DATA MARKERS",null,75,"xlXYScatterLinesNoMarkers"]
[null,"SCATTER WITH SMOOTH LINES","Bodový s vyhlazenými spojnicemi a značkami",72,"xlXYScatterSmooth"]
[null,"SCATTER WITH SMOOTH LINES AND NO DATA MARKERS",null,73,"xlXYScatterSmoothNoMarkers"]
[null,"STOCK"]
[null,"STOCK HLC (HIGH-LOW-CLOSE)","Burzovní (max, min, závěr)",88,"xlStockHLC"]
[null,"STOCK OHLC (OPEN-HIGH-LOW-CLOSE)","Burzovní (otevření, max, min, závěr)",89,"xlStockOHLC"]
[null,"STOCK VHLC (VOLUME-HIGH-LOW-CLOSE)","Burzovní (objem, max, min, závěr)",90,"xlStockVHLC"]
[null,"STOCK VOHLC (VOLUME-OPEN-HIGH-LOW-CLOSE)","Burzovní (objem, otevření, max, min, závěr)",91,"xlStockVOHLC"]
[null,"SURFACE"]
[null,"3D SURFACE","Prostorový povrchový",83,"xlSurface"]
[null,"3D SURFACE WIREFRAME","Prostorový dratěný povrchový",84,"xlSurfaceWireframe"]
[null,"SURFACE TOP VIEW","Obrysový",85,"xlSurfaceTopView"]
[null,"SURFACE TOP VIEW WIREFRAME",null,86,"xlSurfaceTopViewWireframe"]
[null,"Excel 2016"]
[]
[null,"SURFACE"]
[null,"TREEMAP","Stromová mapa",117]
[null,"Waterfall Chart"]
[null,"Sunburst"]