Forum Discussion
Roger895
Jan 28, 2020Copper Contributor
Creating a simple chart in excel -- why is it so hard?
I want to create a simple chart. Example -- I want to chart the following data. I have a service that uses a freemium model. The first 20 accounts are free, but I will charge $5 per account for...
PReagan
Jan 28, 2020Bronze Contributor
Hello Roger895,
In the "Accounts" column enter all values 1 thru 5000 with autofill.
In cell C4 enter the formula:
=IF($B4<=20,0,IF($B4>=475,$E$4*475,$B4*$E$4))
and copy down using autofill.
- Roger895Jan 28, 2020Copper Contributor
PReagan -- thanks for the tip. I put the data together to show the issue with my charting problem -- it was rushed. Any ideas on the chart?
- SergeiBaklanJan 28, 2020MVP
It looks like you need to click Edit on right pane and assign Accounts column as horizontal axis, plus remove it from Series.