• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

price evolution excel over 10,000 products

Alina_T

New Member
Hi there! Please help me create a price evolution chart in Excel. I have over 10,000 products with different values, and a product can be purchased at three different prices in a month. The Excel file is a result of a pivot table. I am not sure how to organize the data to get the evolution chart. I understand that in Excel, a chart can only show a maximum of 255 products. Can I highlight the data differently using conditional formatting? What would be the best idea? Thank you in advance!
 

Attachments

  • help_price evolution.xlsx
    10.3 KB · Views: 5
Alina_T
Could You send raw data instead of Your result of a pivot table?
... it will be more useful.
You sample data has many same cod_mat's.
... Are those different products?
... Many of those has only one value over zero ... how to show evolution?
 
Back
Top