Search for answers here or ask a question
0

Existing or custom area chart with measure for x axis.

This is quite obscure so not sure if possible, but is it possible to create some sort of stacked area chart where the X-Axis is a rank (so numeric) instead of a dimension (so 1,2,3,4,5) and the Y-Axis is a numeric value as well. I believe it might be called a decay chart (from wikipedia)?

 

 

I tried to create a version in Pyramid by using a scatter chart but really need these to be area charts so you can overlay the years if possible but they don't offer a x-axis as a measure.

Example:

 

 

ideally we'd want it to look like this (produced in excel)

 

 

I've had a look at market place for charts, but couldn't find any suitable (heat maps look great though!) and I dont have skillset to code my own so was wondering if a, it can't be created, is there a resource online where I could find what I'm looking for? or is it something that could be added to a new version similar to waterfalls?

 

Thanks

 

Nick

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • just to add the final version in excel, how it was achieved was each reference was given a rank value based on its exposure so the risk with highest exposure for X year was renamed to 1, and similarly for Y year the highest risk would also be renamed 1 (albeit two different risks) so you could overlay.

    Like
  • Hi Nicholas,

    sorry that nobody answered so far. Let me check internally if we can find someone to help you.
    Rgs
    Christian

    Like
  • Hi Nicholas, 

    Have you tried making years a dimension instead of a measure?

    Thanks,

    Yash

    Like
    • Avi PerezAdmin
    • "making the sophisticated simple"
    • AviPerez
    • 13 days ago
    • Reported - view

    It's quite difficult to understand exactly what you want. Please upload a sample dataset in an Excel file with the chart you reference.

    Like
Like Follow
  • 13 days agoLast active
  • 4Replies
  • 28Views
  • 4 Following