[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

Chart help..

The attached image shows 2 charts (A and B).

In chart A, the data source is:     =SERIES(Formulas!$C$10,,Formulas!$D$10:$AA$10,1)

Q1: What these charts are called (they occupy single cell). I think they have a special name.
Q2. How one start a new chart like this for another data source, for example:
        =SERIES(Formulas!$C$16,,Formulas!$D$16:$AA$16,1)
FYI, when I copy and pasted chart A to a new location and change 10 (three places) to 16 in this data source formula. It doesn't display the data because the original chart A has data values like 2.3, 4.5, etc. whereas the new series for row 16 has series like 116, 189, etc. So, the scalability is my problem here. I guess if I start a fresh chart, then I may be having a good control about this scalability.
Q3: The chart B is not selectable. I do not know what is the proper name for chart B either, or how to create it. Please give me some help with these 3 questions.

Thank you.
Chart.png
0
Mike Eghtebas
Asked:
Mike Eghtebas
  • 2
1 Solution
 
Rgonzo1971Commented:
Hi,

A1 Sparlines

A2 Goto Insert / Sparklines /
Choose the chart you want

Then the range of your data and cell where the Sparkline chart will be

Regards
0
 
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Thank you for the response.

As shown on the attached imge, after insert/Sparklines, I got "Data Source Reference is not valid" message.

Do you have any idea how I can handle this?

Is Q2 created in the same manner?

Mike
sparkline.png
0
 
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
Thank you.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now