incorrect series data in dynamic chart

[jago]

hi,
attached is file with embedded macro, where i should see a single series
line chart using col A as dates series (where there seems to be no problem)
and utilize named ranges (see row 122) to seek the corresponding results for those dates.
extra series data seems to show up on all, with a puzzling (to me) reference to row 1
when any of the series in the new chart are clicked. there should be only one series per chart.
edit: short story i am getting all 32 avail columns instead of just the one chosen category.

when macro button is executed there are input boxes to enter series name (use any of choices listed below, or on first row of sheet) and number of days (please use any number up to 120 max).

categories: n0 n1 n2 n3 t0 t1 t2 t3 a0 a1 a2 a3 r0 r1 r2 r3 g0 g1 g2 g3 o0 o1 o2 o3 f0 f1 f2 f3 e1 e2 e3 e4

FORUM_chart_030215.xlsm

ps, i am on excel 2013. the VBA code has some notated lines irrelevant to this file.

thanks in advance , john.

[Andy Pope]

If you use Charts.Add then all data in the current region will be used in the chart.
The revised code removes all automatic series and create single new series on specified data.

Please Login or Register  to view this content.

[jago]

Andy
thank you so much , this appears to work fine.

[jago]

hi
unfortunately months later i still have struggled to get a consistent result without errors..
my big file crashes at Charts.Add
(the sample file included above shows the multiple series in error, and may not crash just due to smaller region size?)
i believe Charts.Add may be inherently unstable in 2013?
see this from the Office Dev Center website:
Charts.Add method
Office 2013 Other Versions
This object, member, or enumeration is deprecated and is not intended to be used in your code.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

heres the crash message:
Problem signature:
Problem Event Name: APPCRASH
Application Name: EXCEL.EXE
Application Version: 15.0.4727.1000
Application Timestamp: 55521d8a
Fault Module Name: EXCEL.EXE
Fault Module Version: 15.0.4727.1000
Fault Module Timestamp: 55521d8a
Exception Code: c0000005
Exception Offset: 0026a927
OS Version: 6.1.7601.2.1.0.768.3
Locale ID: 1033

Additional information about the problem:
LCID: 1033
skulcid: 1033


is there a substitute for charts.add for 2013??

thanks and regards john

[Andy Pope]

If you check the object model for Excel 2013 you will see it now uses AddChart2 and AddChart is hidden.

there is also chartobjects.add

whatever way try and do so with the active cell being in empty space.